IVPPH
Back to current versionRestore this version

Table of Contents

PAY HEADERS INTERFACE FILE#

The Pay Headers Interface File screen is used to import historical employee payroll information at a summary level into the software data structures.

Pay Headers Interface File data is maintained on the INF_CV_PAYHEADERS table.

ID
This field uniquely identifies the pay header record within the data base.
ENTITY_CODEVarchar2(16)YNot moved to the software data structures, but used for validation of the employment record. Validation: The Entity Code provided must be defined on P2K_CM_ENTITIES
PERSON_CODEVarchar2(16)YNot moved to the P2K_CM_LOCATIONS table, but used for validation of the employment record. Validation: Must be a valid PERSON_CODE already defined on the P2K_HR_IDENTITIES table.
EMPLOYMENT_TYPEVarchar2(30) Not moved to the software structures, but used for validation. Validation: The employee must have an active employment record for this employment type. Must be one of the fixed lexicon values from X_EMPLOYMENT_TYPE. Derivation: If you do not provide an employment type value, the conversion application will look for any P2K_HR_EMPLOYMENTS record that matches the other criteria. Suggestion: If you are loading employees, you can set this field to a fixed value of ‘01’.
HIRE_DATEDate() Not moved to the software structures, but used for validation of the employment record. Derivation: If you do not provide a hire date, the conversion application will look for any P2K_HR_EMPLOYMENTS record that matches the other criteria. Validation: Must be a valid date.
PAY_NUMBERNumber(5)Y
USER_NAMEVarchar2(30)
UNIT_CODEVarchar2(16)Y
GROUP_CODEVarchar2(16)Y
COUNTRY_CODEVarchar2(16)Y
STATE_PROVINCE_CODE_HOMEVarchar2(16)Y
STATE_PROVINCE_CODE_WORKVarchar2(16)Y
PAY_CATEGORY_CODEVarchar2(16)Y
PAY_CALENDAR_CODEVarchar2(16)Y
PAY_PERIODNumber(10)Y
PAYROLL_CODEVarchar2(16)Y
BATCH_NUMBERNumber(10)
PAY_RUN_NUMBERNumber(10)
SCHOOL_DISTRICT_CODEVarchar2(16)
GEO_CODE_HOMEVarchar2(16)
GEO_CODE_WORKVarchar2(16)
AUDITEDVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True.
CHECK_NUMBERNumber(10)
FINAL_PAY_METHODVarchar2(30) Validation: Must be one of the fixed lexicon values from X_FINAL_PAY_METHOD.
FIRST_PAY_IN_MONTHVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True.
FIRST_PAY_IN_PERIODVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True.
HAND_CHECKVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True.
PAY_BY_CHECKVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True.
PAY_HEADER_SOURCEVarchar2(30) Validation: Must be one of the fixed lexicon values from X_PAY_HEADER_SOURCE
PAY_HEADER_STAGEVarchar2(30) Recommendation: Set this value to "70" (Closed)
Validation: Must be one of the fixed lexicon values from X_PAY_HEADER_STAGE
PAY_RUN_SEQUENCENumber(5)
POSTED_BENEFITSVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True
POSTED_ATTENDANCEVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True
QUICK_PAYVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True
TAX_WEEKSNumber(18)
TIMESHEET_RETURNEDVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True
CHECK_AMOUNTNumber(14)
PAY_ISSUE_DATEDate() Must be a valid date.
SUNDRY_ATTACHEDVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True
JOURNALIZEDVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True
REVERSAL_PAY_NUMBERNumber(5)
ASSIGNMENT_CODEVarchar2(16)
ASSIGNMENT_START_DATEDate()
JOURNALIZED_FUNDVarchar2(4)