!!!Alias: [IVPPH]
(INF_CV_PAYHEADERS)

The INF_CV_PAYHEADERS table is used to import historical employee payroll information at a summary level into the software data structures.  


!!Table Columns
\\
||Column name||Data Type / Size||Mand.||Notes
|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
|[ENTITY_CODE]|Varchar2(16)|Y|Not 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_CODE]|Varchar2(16)|Y|Not 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_TYPE]|Varchar2(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_DATE]|Date()| |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_NUMBER]|Number(5)|Y|
|[USER_NAME]|Varchar2(30)| |
|[UNIT_CODE]|Varchar2(16)|Y|
|[GROUP_CODE]|Varchar2(16)|Y|
|[COUNTRY_CODE]|Varchar2(16)|Y|
|[HOME_STATE_PROVINCE_CODE]|Varchar2(16)|Y|
|[WORK_STATE_PROVINCE_CODE]|Varchar2(16)|Y|
|[PAY_CATEGORY_CODE]|Varchar2(16)|Y|
|[PAY_CALENDAR_CODE]|Varchar2(16)|Y|
|[PAY_PERIOD]|Number(10)|Y|
|[PAYROLL_CODE]|Varchar2(16)|Y|
|[BATCH_NUMBER]|Number(10)| |
|[PAY_RUN_NUMBER]|Number(10)| |
|[SCHOOL_DISTRICT_CODE]|Varchar2(16)| |
|[GEO_CODE_HOME]|Varchar2(16)| |
|[GEO_CODE_WORK]|Varchar2(16)| |
|[AUDITED]|Varchar2(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_NUMBER]|Number(10)| |
|[FINAL_PAY_METHOD]|Varchar2(30)| |Validation:	Must be one of the fixed lexicon values from [X_FINAL_PAY_METHOD].
|[FIRST_PAY_IN_MONTH]|Varchar2(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_PERIOD]|Varchar2(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_CHECK]|Varchar2(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_CHECK]|Varchar2(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_SOURCE]|Varchar2(30)| | Validation:	Must be one of the fixed lexicon values from [X_PAY_HEADER_SOURCE]
|[PAY_HEADER_STAGE]|Varchar2(30)| |  Recommendation: Set this value to "70" (Closed)\\Validation:	Must be one of the fixed lexicon values from [X_PAY_HEADER_STAGE]
|[PAY_RUN_SEQUENCE]|Number(5)| |
|[POSTED_BENEFITS]|Varchar2(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_ATTENDANCE]|Varchar2(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_PAY]|Varchar2(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_WEEKS]|Number(18)| |
|[TIMESHEET_RETURNED]|Varchar2(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_AMOUNT]|Number(14)| |
|[PAY_ISSUE_DATE]|Date()| |Must be a valid date.
|[SUNDRY_ATTACHED]|Varchar2(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
|[JOURNALIZED]|Varchar2(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_NUMBER]|Number(5)| |
|[ASSIGNMENT_CODE]|Varchar2(16)| |
|[ASSIGNMENT_START_DATE]|Date()| |
|[JOURNALIZED_FUND]|Varchar2(4)| |
|[CREATE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CREATE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.


----
![Notes|Edit:Internal.INF_CV_PAYHEADERS] 	
[{InsertPage page='Internal.INF_CV_PAYHEADERS' default='Click to create a new notes page'}]