PIP



Column Section Relationship Section Top of Page


Table-level Detail

Description: PIP
Definition: Pip Definition Table
Table Type: REFERENCE





Column Detail - PIP


Column Name Type Null? Definition
LOCATION_CD DOUBLE N Location for pip definition. The pip definition can be flexed by position_cd and then by location_cd. The pip definition can also be flexed by prsnl_id and then by location_cd.
PIP_ID DOUBLE N Unique identifier for pip definition.
POSITION_CD DOUBLE N Position_cd for pip definition. The pip definition can be flexed by position_cd and then by location_cd.
PRSNL_ID DOUBLE N Prsnl_id for pip definition. The pip definition can be flexed by prsnl_id and then by location.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PIP


Child Column in PIP(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


PIP_COLUMN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PIP COLUMN
Definition: PIP Column Definition.
Table Type: REFERENCE





Column Detail - PIP_COLUMN


Column Name Type Null? Definition
COLUMN_TYPE_CD DOUBLE N Type of column
PIP_COLUMN_ID DOUBLE N Unique column identifier
PIP_SECTION_ID DOUBLE N ID of section column is within.
PRSNL_ID DOUBLE N Prsnl ID of column definition. If this is 0, then this column appears on everyones section. Otherwise this column only appears on the identified users PIP.
SEQUENCE DOUBLE Y Sequence of column.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PIP_COLUMN


Child Column in PIP_COLUMN(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


PIP_PREFS



Column Section Top of Page


Table-level Detail

Description: PIP PREFS
Definition: PIP properties for section and column definitions.
Table Type: REFERENCE





Column Detail - PIP_PREFS


Column Name Type Null? Definition
MERGE_ID DOUBLE N ID of property value.
MERGE_NAME VARCHAR(100) Y Name of merge entity specified in MERGE_ID.
PARENT_ENTITY_ID DOUBLE N ID of parent Entity.
PARENT_ENTITY_NAME VARCHAR(100) Y Name of entity specified in PARENT_ENTITY_ID.
PIP_PREFS_ID DOUBLE N Unique identifier for preference.
PREF_NAME VARCHAR(100) Y Name of preference.
PREF_VALUE VARCHAR(255) Y Value of preference.
PRSNL_ID DOUBLE N ID of user preference is specified for. 0 indicates it is the default.
SEQUENCE DOUBLE Y sequence of preference.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


PIP_SECTION



Column Section Top of Page


Table-level Detail

Description: PIP SECTION
Definition: Defines PIP section.
Table Type: REFERENCE





Column Detail - PIP_SECTION


Column Name Type Null? Definition
PIP_ID DOUBLE N ID of pip section is on.
PIP_SECTION_ID DOUBLE N Unique ID of section.
SECTION_TYPE_CD DOUBLE N Type of section.
SEQUENCE DOUBLE Y Sequence of section.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.