P 2 K_PR_LOADED_PAY_LINES
Back to current versionRestore this version

Alias: PLPL#

(P2K_PR_LOADED_PAY_LINES)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-PR45


Loaded Pay Lines

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
ENTITY_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(2)X_EMPLOYMENT_TYPEY
CATEGORY_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODE
GOVERNMENT_CODEVarchar2(16)GOVERNMENT CODE
START_DATEDate()DATEY
END_DATEDate()DATE
PAY_PERIODNumber(10)NUMBER10
TIME_CODEVarchar2(16)CODE
PC_CODENumber(4)CODE NUMERIC
TIME_OR_AMOUNTNumber(18)AMT12V6
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(2)X_RATE_BASIS
POSITION_CODEVarchar2(16)CODE
JOB_CODEVarchar2(16)CODE
DEPARTMENT_CODEVarchar2(16)CODE
BATCH_CODEVarchar2(16)CODE
PREMIUM_CODE1Varchar2(16)CODE
PREMIUM_CODE2Varchar2(16)CODE
PREMIUM_CODE3Varchar2(16)CODE
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
COST_CENTER_CODEVarchar2(16)CODE
WORK_IN_PROCESSVarchar2(1)TOGGLE
REFERENCE_INFOVarchar2(2000)VARCHAR2000
SOURCE_REFERENCEVarchar2(50)VARCHAR50
REASON_FOR_TIMEVarchar2(2)X_REASON_FOR_TIME
LEAVE_REASONVarchar2(2)X_LEAVE_REASON
DESTINATION_TYPEVarchar2(2)X_DESTINATION_TYPE
AUDIT_TEXTVarchar2(4000)VARCHAR4000
BATCH_NUMBERNumber(10)NUMBER10
UPTL_STATUSVarchar2(2)X_UPTL_STATUS
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
WORK_ORDERVarchar2(50)VARCHAR50
TRANSACTION_POINTERVarchar2(30)VARCHAR30
ASSIGNMENT_CODEVarchar2(16)CODE
UNIT_CODEVarchar2(16)CODE
WORK_RULE_CODEVarchar2(16)CODE

Derived Fields#

Column Name
DRV_ID

User Fields: Allowed
Audit Logging: Not Allowed

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation