This page (revision-64) was last changed on 19-Mar-2024 10:20 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
64 19-Mar-2024 10:20 113 KB Kevin Higgs to previous
63 19-Mar-2024 10:13 63 KB Kevin Higgs to previous | to last
62 19-Mar-2024 10:05 63 KB Kevin Higgs to previous | to last
61 19-Mar-2024 10:04 63 KB Kevin Higgs to previous | to last

Page References

Incoming links Outgoing links
UPPHF
UPPHF

Version management

Difference between version and

At line 8 changed one line
The following lexicons are provided by [{$applicationname}] and used for UPPHF Pay History Interface.
The following lexicons are provided by Personality and used for UPPHF Pay History Interface.
At line 18 changed one line
X_INF_VARIABLE_NAME contains a list of system defined variables that are eligible by Interface type. The following list describes each variable and the usage for Interface Type 32 - Pay History Interface.
X_INF_VARIABLE_NAME contains a list of system defined variables that are eligible by Interface type. The following list describes each variable and the usage for [Interface Type 32 - Pay History Interface|X_INF_VARIABLE_NAME (32)]
At line 20 removed 166 lines
%%zebra-table
||Saved\\Value||Displayed Value||Source of Data||Comments
| 320001 | Execution ID | From Execution ID of the [UPPHF] run|
| 320002 | XML Tag | |Indicates this Rec#/Fld# is for XML tag.\\ \\You should enter the XML tag in the XML Tag field, if XML Tag field is not specified, the field name is used as XML tag.\\ \\e.g. <Request> or </Request> as XML tag.\\ \\You should use one of the following ways to define XML tags:\\1) use 320002-XML tag for all Begin and End tags\\i.e. you specify <Request> and </Request>\\2) use 320604-XML Begin tag and 320605-XML End tag.\\ \\ This allows you to use XML tag option to indicate if the XML tag is mandatory or optional.\\ \\You must not use 320002-XML tag to mix with 320604/320605 definition.
| 320003 | Constant Value | |You should specify the Constant to be used in [IDIF] Constant Value field
| 320004 | System Date/Time | The current system date and time with following, select:to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')|You can use derivation expression SUBSTR to retrieve Date Only or Time Only
| 320005 | From Pay Period | This field holds the earliest pay period that have been processed from all pay headers| This can be used for Header or Trailer record
| 320006 | To Pay Period | This field holds the latest pay period that have been processed from all pay headers|This can be used for Header or Trailer record
| 320007 | Pay Header pph_id | This field holds the id of the current pay header|This can be used in the derivation expression to call some internal [{$applicationname}] functions that needed the pph.id e.g. call Element function to return the value of an element: To retrieve the value of Element 'HOURS COMP TIME'.\\ \\ In Record# 50, Field#20, Variable Name = 'Pay Header [PPH_ID]', then in derivation expression: P2K_PPAMTS.SPELPAY(~,P2K_PPAMTS.SPGETPEL('HOURS COMP TIME'))
| 320008 | Employment eem_id | This field holds the id of the current employment record, from [P2K_HR_EMPLOYMENTS]|This can be used in the derivation expression to call some internal functions that needed the eid.id
| 320009 | Identity eid_id | This field holds the id of the current identity record from [P2K_HR_IDENTITIES]|This can be used in the derivation expression to call some internal functions that needed the [EID_ID]
| 320010 | Person Code | From [P2K_HR_IDENTITIES], [person_code|PERSON_CODE]|
| 320011 | First Name | From [P2K_HR_IDENTITIES], [first_name|FIRST_NAME]|
| 320012 | Last Name | From [P2K_HR_IDENTITIES], [last_name|LAST_NAME]|
| 320013 | First,Last Name |From [P2K_HR_IDENTITIES], [first_name|FIRST_NAME] ', ' [last_name|LAST_NAME] |
| 320014 | Last,First Name | From [P2K_HR_IDENTITIES], [last_name|FIRST_NAME] ', ' [first_name|FIRST_NAME]|
| 320015 | Trial Run | From parameter P_TRIAL (Trial Run)|The value of 'Y' or 'N' is always returned in P_TRIAL.\\If NULL is entered, P_TRIAL is set to 'N'
| 320020 | Batch Number | From [P2K_PR_BATCHES], [batch_number|BATCH_NUMBER]|
| 320030 | Pay Run Number |From [P2K_PR_PAY_RUNS], [pay_run_number|PAY_RUN_NUMBER] |
| 320031 | Pay Run Sequence |From [P2K_PR_PAY_HEADERS], [pay_run_sequence|PAY_RUN_SEQUENCE] |
| 320040 | Hired Date | From [P2K_HR_EMPLOYMENTS], [hire_date|HIRE_DATE]|
| 320041 | Term Date | From [P2K_HR_EMPLOYMENTS], [termination_date|TERMINATION_DATE]|
| 320042 | Seniority Date |From [P2K_HR_EMPLOYMENTS], [seniority_date|SENIORITY_DATE] |
| 320043 | First Work Date |From [P2K_HR_EMPLOYMENTS], [first_work_date|FIRST_WORK_DATE] |
| 320044 | Last Work Date | From [P2K_HR_EMPLOYMENTS], [last_work_date|LAST_WORK_DATE]|
| 320100 | Pay Header Stage | From [P2K_PR_PAY_HEADERS], [pay_header_stage|PAY_HEADER_STAGE]|
| 320101 | Pay Number | From [P2K_PR_PAY_HEADERS], [pay_number|PAY_NUMBER]|
| 320102 | Pay Period | From [P2K_PR_PAY_HEADERS], [pay_period|PAY_PERIOD]|
| 320103 | Pay Period Start |From [P2K_PR_PAY_PERIODS], [pay_period_start_date|PAY_PERIOD_START_DATE] of the pay header |
| 320104 | Pay Period End Date |From [P2K_PR_PAY_PERIODS], [pay_period_end_date|PAY_PERIOD_END_DATE] of the pay header |
| 320105 | Pay Issue Date | From [P2K_PR_PAY_HEADERS], [pay_issue_date|PAY_ISSUE_DATE]|
| 320106 | Period Fiscal | From Pay Period Fiscal of Pay Header|
| 320107 | Period Fiscal Start |From Fiscal Start Date of Pay Period Fiscal |
| 320108 | Period Fiscal End | From Fiscal End Date of Pay Period Fiscal|
| 320109 | Issue Fiscal | From Pay Issue Fiscal of Pay Header|
| 320110 | Issue Fiscal Start |From Fiscal Start Date of Pay Issue Fiscal |
| 320111 | Issue Fiscal End | From Fiscal End Date of Pay Issue Fiscal|
| 320200 | G/L Company Code | From [P2K_CM_ENTITIES], [GL Company Code|DGC_ID] |
| 320201 | Entity Code | From [P2K_CM_ENTITIES], [Entity Code|ENTITY_CODE] |
| 320202 | Entity Name | From [P2K_CM_ENTITIES], [Entity Name|ENTITY_NAME]|
| 320203 | Payroll Code |From [P2K_PR_PAYROLLS], [Payroll Code|PAYROLL_CODE] |
| 320204 | Payroll Desc | From [P2K_PR_PAYROLLS], [Payroll description|DESCRIPTION]|
| 320205 | Unit Code | From [P2K_CM_UNITS], [Unit Code|UNIT_CODE]|
| 320206 | Unit Name | From [P2K_CM_UNIT_DETAILS], [Unit Name|UNIT_NAME]|
| 320207 | Group Code | From [P2K_CM_GROUPS],[Group Code|GROUP_CODE] |
| 320208 | Group Desc | From [P2K_CM_GROUP_DETAILS], [Group Description|DESCRIPTION]|
| 320209 | Department Code (32) |From Pay Header assignment [Department Code|DEPARTMENT_CODE] on [P2K_CM_DEPARTMENTS] or Pay Line [Department Code|DEPARTMENT_CODE] if exists |
| 320210 | Department Name (32) | From Pay Header assignment [Department Name|DEPARTMENT_NAME] on [P2K_CM_DEPARTMENT_DETAILS] or Pay Line [Department name|DEPARTMENT_NAME] if exists|
| 320211 | Job Code (32) | From Pay Header assignment [Job Code|JOB_CODE] on [P2K_CM_JOBS] or Pay Line [Job Code|JOB_CODE] if exists|
| 320212 | Job Title (32) | From Pay Header assignment [Job Title|JOB_TITLE] on [P2K_CM_JOB_DETAILS] or Pay Line [Job Title|JOB_TITLE] if exists|
| 320213 | Position Code (32) | From Pay Header assignment [Position Code|POSITION_CODE] on [P2K_CM_POSITIONS] or Pay Line [Position Code|POSITION_CODE] if exists|
| 320214 | Position Title (32) | From Pay Header assignment [Position Title|POSITION_TITLE] on [P2K_CM_POSITION_DETAILS] or Pay Line [Position Title|POSITION_TITLE] if exists|
| 320215 | Assignment Code (32) | From Pay Header [assignment Code|ASSIGNMENT_CODE] on [P2K_HR_ASSIGNMENTS] or Pay Line [assignment Code|ASSIGNMENT_CODE] if exists|
| 320216 | Assignment Title (32) | From Pay Header [assignment Title|ASSIGNMENT_TITLE] on [P2K_HR_ASSIGNMENT_DETAILS] or Pay Line assignment Code Title if exists|
| 320217 | Pay Category Code (32) | From Pay Header [pay_category_code|PAY_CATEGORY_CODE] on [P2K_PR_PAY_CATEGORIES]|
| 320218 | Check Number (32) | From Pay Header [Check Number|CHECK_NUMBER] on [P2K_PR_CHECKS]|
| 320219 | Check Amount (32) | From Pay Header [Check Amount|CHECK_AMOUNT] on [P2K_PR_CHECKS]|
| 320220 | User Name (32) | From Pay Header [User Name|MUS_ID] on [P2K_AM_USERS] |
| 320221 | Work State/Prov (32) |From Pay Header [Work State/Prov|DSP_ID_WORK] on [P2K_PR_PAY_HEADERS] |
| 320222 | Res State/Prov (32) | From Pay Header [Residence State/Prov|DSP_ID_HOME] on [P2K_PR_PAY_HEADERS]|
| 320223 | Work GEO Code (32) | From Pay Header [Work Jurisdiction GEO Code|GEO_CODE] on [P2K_CM_TAX_JURISDICTIONS]|
| 320224 | Res GEO Code (32) | From Pay Header [Residence Jurisdiction GEO Code|DTX_ID_HOME] on [P2K_CM_TAX_JURISDICTIONS]|
| 320225 | Work Jurisdiction (32) |From Pay Header [Work Jurisdiction| DTX_ID_WORK] on [P2K_PR_PAY_HEADERS]|
| 320226 | Res Jurisdiction (32) | From Pay Header [Residence Jurisdiction|DTX_ID_HOME] on [P2K_PR_PAY_HEADERS]|
| 320227 | School District (32) | From Pay Header [School District|DSD_ID] on [P2K_PR_PAY_HEADERS]|
| 320230 | Std Wage (eas) (32) | From Pay Header [Assignment Std Wage|STD_WAGE_RATE]|
| 320231 | Wage Basis (eas) (32) |From Pay Header [Assignment Wage Basis|STD_WAGE_RATE_BASIS] |
| 320232 | Authorization Code (32) |Authorization area is from pay header or pay line's assignment, then position, then department|
| 320300 | PC Code (32) |The [PC Code|PC_CODE] of the current pay line detail or pay amount |
| 320301 | PC Abbrev (32) |The [PC Abbreviation|PC_ABBREVIATION] of the current pay line detail or pay amount |
| 320302 | PC Amount (32) | The [PC Amount|AMOUNT] of the current pay line detail or pay amount|
| 320303 | Element Code (32) |You should specify the '[Element Code|ELEMENT_CODE]' in [IDIF] Constant Value |
| 320304 | Element PC Value (32) | You should specify the '[Element Code|ELEMENT_CODE]' in [IDIF] Constant Value|If the PC Code of the current pay line detail or pay amount is in the [element|PAY ELEMENTS], then the PC Amount is included
| 320305 | Element Desc (32) |You should specify the '[Element Code|ELEMENT_CODE]' in [IDIF] Constant Value |
| 320306 | Element pph Value (32) | You should specify the '[Element Code|ELEMENT_CODE]' in [IDIF] Constant Value|this returns the Element Value of this Pay Header [PPH_ID]
| 320400 | Start Date (ppl) (32) |From Pay Line [Start Date|START_DATE] on [P2K_PR_PAY_LINES] |
| 320401 | Time (ppl) (32) | From Pay Line [Time|TIME_ENTERED] on [P2K_PR_PAY_LINES]|
| 320402 | Time Basis (ppl) (32) |From Pay Line [Time Basis|TIME_BASIS] on [P2K_PR_PAY_LINES] |
| 320403 | Std Wage (ppl) (32) | From Pay Line [Std Wage|STD_WAGE_RATE] on [P2K_PR_PAY_LINES]|
| 320404 | Wage Basis (ppl) (32) |From Pay Line [Wage Basis|STD_WAGE_RATE_BASIS] on [P2K_PR_PAY_LINES] |
| 320405 | Cost Center (ppl) (32) |From Pay Line [Cost Center|COST_CENTER_CODE] on [P2K_CM_COST_CENTERS] |
| 320406 | Cost Center Desc (32) | From Pay Line [Cost Center description|DESCRIPTION] on [P2K_CM_COST_CENTERS]|
| 320407 | Work Order (ppl) (32) | From Pay Line [Work Order|WORK_ORDER] on [P2K_PR_PAY_LINES]|
| 320408 | Reference Info (ppl) (32) |From Pay Line [Reference Info|REFERENCE_INFO] on [P2K_PR_PAY_LINES] |
| 320409 | Tran Pointer (ppl) (32) | From Pay Line [Transaction Pointer|TRANSACTION_POINTER] on [P2K_PR_PAY_LINES]|
| 320410 | Pay Line ID (ppl_id) (32) |From [Pay Line ID|PPL_ID] |
| 320411 | Pay Line Detail (ppld_id) (32) |From [Pay Line Detail ID|PPLD_ID] |
| 320500 | Wage Rate (ppld) (32) | From Pay Line Detail [Wage Rate|WAGE_RATE] on [P2K_PR_PAY_LINE_DETAILS]|
| 320501 | Rate Basis (ppld) (32) | From Pay Line Detail [Rate Basis|RATE_BASIS] on [P2K_PR_PAY_LINE_DETAILS]|
| 320502 | Tran Pointer (ppld) (32) | From Pay Line Detail [Transaction Pointer|TRANSACTION_POINTER] on [P2K_PR_PAY_LINE_DETAILS]|
| 320600 | Total Value (32) | User should specify the Rec# and Field # to be totaled in [IDIF] Constant Value field e.g. if Rec # 50 Field # 70 specifies the hours for each employee and need to be totaled for the trailer record, then for trailer record entry, you should specify 'Total Value' with Constant Value = 5070|This Total Value is available for Header and Trailer records. Multiple Rec# and Field # are allowed in the Constant field e.g. [[611] + [[612] + [[613] + [[623] - [[624]. This means calculate the Totals for Rec# 61 Fld# 1 + Rec# 61 Fld# 2 + Rec# 61 Fld# 3 + Rec# 62 Fld# 3 - Rec# 62 Fld# 4. Any arithmetic operator can be used: +, -, *, /Note: The Accum Option and Total Option must be set for the Rec# Fld# that are specified in this Constant field, i.e.Rec# 61 Fld# 1 etc
| 320601 | Detail Record Count (32) | Contains the Record Count of each set of Rec# 30-69 in the interface file, i.e. one set of [IDIF] Record Type of 'DetailRecord', can be used as employee count e.g. if an employee's one detail record generates three different Record types with Rec# 50, 60, 65, it counts as one because it is for one detail record|This Record Count is available for Header and Trailer records
| 320602 | All Detail Count (32) | Contains the Record Count of all Rec# 30-69 in the interface file e.g. if an employee's one detail record generates 3 different Record types with Rec# 50, 60, 65, it counts as 3 because there are 3 entries generated on interface file|This Record Count is available for Header and Trailer records
| 320603 | User Calc (32) |Indicates this Rec#/Fld# will invoke a UserCalc. You should enter the UserCalc Name in the Constant Value field |
| 320604 | XML Begin Tag (32) |Indicates this Rec#/Fld# is for XML Begin tag |You should enter the XML tag in the XML tag field, if XML tag field is not specified, the Field name is used as XML tag. You should specify XML tag option for this field. If XML tag option is not specified, this XML tag is an optional tag. If you use 320604-XML Begin tag to define the XML tags, you must use 320605-XML End tag to pair with the XML Begin tag. You should use one of the following ways to define XML tags:1) use 320002-XML tag for all Begin and End tags i.e. you specify <Request> and </Request> 2) use 320604-XML Begin tag and 320605-XML End tag . This allows you to use XML tag option to indicate if the XML tag is mandatory or optional. You must not use 320002-XML tag to mix with 320604/320605 definition
| 320605 | XML End Tag (32) |Indicates this Rec#/Fld# is for XML End tag |See 320604- XML Begin tag for detail
| 320606 | UDF (EID) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_IDENTITIES] (EID)|You must define the UDF on [IMUF] screen for [P2K_HR_IDENTITIES] and then enter the value on [IEID] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320607 | UDF (EEM) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_EMPLOYMENTS] (EEM)|You must define the UDF on [IMUF] screen for [P2K_HR_EMPLOYMENTS] and then enter the value on [IEEI] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320608 | UDF (EPS) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_PERSONALS] (EPS)|You must define the UDF on [IMUF] screen for [P2K_HR_PERSONALS] and then enter the value on [IEPI] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320610 | UDF (EASD) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|User must define the UDF on [IMUF] screen for [P2K_HR_ASSIGNMENT_DETAILS] and then enter the value on [IEAS] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-UpdateRecord', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen.
| 320621 | UDF (DED) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_ENTITY_DETAILS] (DED)|User must define the UDF on [IMUF] screen for [P2K_CM_ENTITY_DETAILS] and then enter the value on [IDEN] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320623 | UDF (DDD) (32) |Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_DEPARTMENT_DETAILS] (EASD)|[P2K_CM_DEPARTMENT_DETAILS] and then enter the value on [IDDP] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320624 | UDF (DLN) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_LOCATIONS] (DLN)|User must define the UDF on [IMUF] screen for [P2K_CM_LOCATIONS] and then enter the value on [IDLN] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320626 | UDF (DUD) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_UNIT_DETAILS] (DUD)|User must define the UDF on [IMUF] screen for [P2K_CM_UNIT_DETAILS] and then enter the value on [IDUN] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320628 | UDF (DGD) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_GROUP_DETAILS] (DGD)|User must define the UDF on [IMUF] screen for [P2K_CM_GROUP_DETAILS] and then enter the value on [IDGR] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be Inserted or Updated, you do not need to set up UDF on [IMUF] screen
| 320629 | UDF (PRN) (32) |Indicates this Rec#/Fld# contains a UDF value from [P2K_PR_PAY_RUNS] (PRN) |User must define the UDF on [IMUF] screen for [P2K_PR_PAY_RUNS] and then enter the value on [IPVP] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320630 | UDF (PPH) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_PR_PAY_LINES] (PPL)|User must define the UDF on [IMUF] screen for [P2K_PR_PAY_LINES] and then enter the value on [IPPH] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320631 | UDF (PPL) (32) | |
| 320650 | Statistic Amt (IEST) (65) | Indicates this Rec#/Fld# contains a Statistics value from [P2K_HR_STATISTICS] (EST)|User must define the Statistics Code on [IDSC] screen for [P2K_CM_STATISTIC_COMPONENTS] and then enter the value on [IEST] screen. On [IDIF] screen, you must enter the [IDSC] Statistics Code in the Constant Value field. On [IDIF] screen, you must enter the [IDSC] Statistics Code in the Constant Value field
| 320700 | Journal Entry ID (PJE) (32) | This field holds the [id|PJE_ID] of the current Journal Entry|
| 320701 | Distr Code (PJE) (32) | From [Distribution Code|DISTRIBUTION_CODE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320702 | Journal Source (PJE) (32) | From [Journal Source|JOURNAL_SOURCE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320703 | G/L Post Number (PJE) (32) | From [GL Post Number|GLPOST_NUMBER]on [P2K_PR_JOURNAL_ENTRIES]|
| 320704 | G/L Post Seq (PJE) (32) | From [GL Post Sequence|GLPOST_SEQUENCE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320705 | Trial Journal (PJE) (32) | From [Trial Journal|TRIAL_JOURNAL] on [P2K_PR_JOURNAL_ENTRIES]|
| 320750 | Journal Detail ID (PJD) (32) |This field holds the [id|PJD_ID] of the current Journal Detail |
| 320751 | Pay Line ID (PJD) (32) | This field holds the [PPL_ID] of the current Journal Detail|
| 320752 | Pay Detail ID (PJD) (32) |This field holds the [PPLD_ID] of the current Journal Detail |
| 320753 | Pay Trans ID (PJD) (32) | This field holds the [PTR_ID] of the current Journal Detail|
| 320754 | G/L Fund ID (PJD) (32) | This field holds the [DGF_ID] of the current Journal Detail|
| 320755 | Time Code PTRC_ID (PJD) (32) |This field holds the [PTRC_ID] of the current Journal Detail |
| 320756 | G/L Eff Date (PJD) (32) | From [GL Effective Date|GL_EFFECTIVE_DATE] on [P2K_PR_JOURNAL_DETAILS]|
| 320757 | G/L Amount (PJD) (32) | From [GL Amount|GL_AMOUNT] on [P2K_PR_JOURNAL_DETAILS]|
| 320758 | G/L Amt DR (PJD) (32) | From [GL Amount|GL_AMOUNT] if amount is positive, otherwise 0|
| 320759 | G/L Amt CR (PJD) (32) | From [GL Amount|GL_AMOUNT] if amount is negative,otherwise 0|
| 320760 | G/L Amt-Financial (PJD) (32) | From [GL Amount|GL_AMOUNT] if the DGA [G/L Account Journal Type|JOURNAL_TYPE] for this PJD = '01-Financial', otherwise 0|
| 320761 | G/L Amt-Statistical (PJD) (32) | From [GL Amount|GL_AMOUNT] if the DGA [G/L Account Journal Type|JOURNAL_TYPE] for this PJD = '01-Financial', otherwise 0|
| 320762 | G/L Amt-Time Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '10- Time', otherwise 0|
| 320763 | G/L Amt-Earn Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '11- Earnings', otherwise 0|
| 320764 | G/L Amt-Dedn Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '12- Deduction', otherwise 0|
| 320765 | G/L Amt-Ben Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '13- Benefit', otherwise 0|
| 320780 | Split Percent (PJD) (32) | From [Split Percent|SPLIT_PERCENT] on [P2K_PR_JOURNAL_DETAILS]|
| 320781 | G/L Detail Seq (PJD) (32) |From [GL Detail Sequence|GL_DETAIL_SEQUENCE] on [P2K_PR_JOURNAL_DETAILS] |
| 320782 | Work Order (PJD) (32) | From [Work Order|WORK_ORDER] on [P2K_PR_JOURNAL_DETAILS]|
| 320783 | G/L Pointer (PJD) (32) |From [GL Pointer|GL_POINTER] on [P2K_PR_JOURNAL_DETAILS] |
| 320800 | G/L Account ID (DGA) (32) |This field holds the [id|DGA_ID] of the G/L Account of current journal entry |
| 320801 | G/L Account Code (DGA) (32) | From [GL Account Code|GL_ACCOUNT_CODE] on [P2K_CM_GL_ACCOUNTS] of current G/L Account|
| 320802 | 0802 Account Type (DGA) (32) | From [GL Account Type|ACCOUNT_TYPE] on [P2K_CM_GL_ACCOUNTS] of current G/L Account|
| 320803 | Journal Type (DGA) (32) | From [Journal Type|JOURNAL_TYPE] on [P2K_CM_GL_ACCOUNTS]|
| 320804 | 0804 Account Usage (DGA) (32) |From [Account Usage|ACCOUNT_USAGE] on [P2K_CM_GL_ACCOUNTS] |
| 320805 | 0805 Account Desc (DGA) (32) | From [Account Desc|DESCRIPTION] on [P2K_CM_GL_ACCOUNTS]|
| 320806 | Distr Mask (DGA) (32) | From [Distribution Mask|DISTRIBUTION_MASK] on [P2K_CM_GL_ACCOUNTS]|
| 320807 | Affects Costing (DGA) (32) |From [Affects Costing|AFFECTS_COSTING] on [P2K_CM_GL_ACCOUNTS] |
| 320808 | Pre Payroll (DGA) (32) | From [Pre Payroll|PRE_PAYROLL] on [P2K_CM_GL_ACCOUNTS]|
| 320809 | Post Payroll (DGA) (32) |From [Post Payroll|POST_PAYROLL] on [P2K_CM_GL_ACCOUNTS] |
| 320810 | Retain Detail (DGA) (32) |From [Retain Detail|RETAIN_DETAIL] on [P2K_CM_GL_ACCOUNTS] |
| 320811 | Accrued Required (DGA) (32) |From [Accrued Required|ACCRUAL_REQUIRED] on [P2K_CM_GL_ACCOUNTS] |
| 320812 | I/C Required (DGA) (32) | From [I/C Required|INTERCOMPANY_REQUIRED] on [P2K_CM_GL_ACCOUNTS]|
| 320813 | Posting Date Method (DGA (32) |From [Posting Date Method|POSTING_DATE_METHOD] on [P2K_CM_GL_ACCOUNTS] |
| 320814 | G/L Acct Suffix (DGA) (32) | From [GL Acct Suffix|GL_ACCOUNT_SUFX]on [P2K_CM_GL_ACCOUNTS]|
| 320815 | Acct Charge To (DGA) (32) | From [Acct Charge To|ACCOUNT_CHARGE_TO] on [P2K_CM_GL_ACCOUNTS]|
| 320900 | Pay Component ID (PPC) (32) |This field holds the [id|PPC_ID] of the Pay Component of current journal detail |
| 320901 | PC Code (PPC) (32) | From [PC Code|PC_CODE] on [P2K_PR_PAY_COMPONENTS]|
| 320902 | PC Abbrev (PPC) (32) |From [PC Abbreviation|PC_ABBREVIATION] on [P2K_PR_PAY_COMPONENTS] |
| 320903 | PC Desc (PPC) (32) | From [PC Description|DESCRIPTION] on [P2K_PR_PAY_COMPONENTS]|
| 320904 | PC Action (PPC) (32) |From [PC Action|PC_ACTION] on [P2K_PR_PAY_COMPONENTS] |
| 320905 | Store Results (PPC) (32) |From [Store Results|STORE_RESULTS] on [P2K_PR_PAY_COMPONENTS] |
| 320920 | PC Usage ID (PCU) (32) | This field holds the [id|PCU_ID] of the Pay Component Usage of the pay component of the current journal detail|
| 320921 | PC Usage Code (PCU) (32) | From [PC Usage Code|PC_USAGE_CODE] on [P2K_PR_PC_USAGES]|
| 320922 | PC Usage Type (PCU) (32) | From [PC Usage Type|PC_USAGE_TYPE] on [P2K_PR_PC_USAGES]|
| 320923 | PC Usage Desc (PCU) (32) | From [PC Usage Description|DESCRIPTION] on [P2K_PR_PC_USAGES]|
| 320924 | Unique Item (PCU) (32) | From [Unique Item|UNIQUE_ITEM] on [P2K_PR_PC_USAGES]|
| 320925 | Mandatory (PCU) (32) | From [Mandatory|MANDATORY] on [P2K_PR_PC_USAGES]|
| 320926 | Legislation (PCU) (32) |From [Legislation|LEGISLATION] on [P2K_PR_PC_USAGES] |
| 320927 | PC G/L Type (PCU) (32) |From [PC GL Type|PC_GL_TYPE] on [P2K_PR_PC_USAGES] |
| 321000 | Pays Per Year (PPP) (32) | |
At line 194 changed 9 lines
Code: - user defined Interface Code
- if IDIF layout is supplied by the system, the Interface Code begins with HL$
Interface Type: - must be 32 – Pay History Interface
File Format: - specifies one of the File Formats from look up list
Form Type: - please select ‘Not Specified’ from look up list, Form Type is not used for UPPHF
Description: - user defined description
File Name: - specifies the default file name, otherwise file name is entered on UPPHF parameter
File Creation Number: - not used
Taxation Level: - please select ‘Not Specified’ from look up list, Taxation Level is not used for UPPHF
;Code:User defined Interface Code\\If IDIF layout is supplied by the system, the Interface Code begins with HL$
;Interface Type:Must be 32 - Pay History Interface
;File Format:Specifies one of the File Formats from look up list
;Form Type:Please select 'Not Specified' from look up list, Form Type is not used for UPPHF
;Description:User defined description
;File Name:Specifies the default file name, otherwise file name is entered on UPPHF parameter. If you use the tokens ''MEX'' or ''DATE'' or ''TIME'' these will be replaced as noted in [P2K_PU.FILE_NAME]. In Non-Trial mode, with ’92-Update Record’ Type and Variable 320016, the File Name will be updated according to the Derivation Expression
;File Creation Number: Specifies the beginning number to be used as File Creation Number. If this field is NULL, when IDIF Record is referencing Variable 320017-IDIF File Creation Number (32), then the default File Creation Number is treated as 0. In Non-Trial mode, with ’92-Update Record’ Type and Variable 320017, the File Creation Number will be updated according to the Derivation Expression e.g. to increment by 1, in Derivation Expression field, enter ~ + 1
;Taxation Level:Please select 'Not Specified' from look up list, Taxation Level is not used for UPPHF
;Record Number:User assigned Record Number\\Each Record Number generates a new line in the interface file.\\The followings are suggested Record Numbers, user can set up their own numbers.
||Record Number||Interface File Records generated
|0|Qualify Records
|1 - 29|Header Records
|30 - 69|Detail Records
|70 - 99|Trailer Records or Update Records
;Field Number:User assigned number
;Name:User assigned field name
;XML Tag:Optional, used for XML File Format only\\If XML Tag is not specified for XML File, then the Name field is used as XML Tag
;Beginning Position:If File Format = 'Fixed Format', you must specify the Beginning position
;Ending Position:If File Format = 'Fixed Format', you must specify the Ending position\\ \\These positions must be continuous without gap, otherwise an error situation will occur.\\ \\Beginning/Ending positions are not needed for xml and other file format.
;Field Type:Indicate the result of the Field Variable is a type of 'Char', 'Number' or 'Date'
;Variable Name:Select from lexicon X_INF_VARIABLE_NAME 32nnnn, refer to lexicon list above
;Sort Sequence:Specifies the Sort Sequence for this Record #, Field #\\ \\Use for Record # with Record Type = 'Detail Record' only\\ \\For Record # with Record Type = 'Detail Level 1' to 'Detail Level 5', it uses the same Sort from Record Type = 'Detail Record' so that the Detail Level n records are followed after the 'Detail Record' e.g. Interface File need to sort by: Department, Employee First Name, Last Name\\- Then for the Fld# entry that specify 'Department', enter sort sequence: 100\\- For the Fld# that specify 'Employee First Name', enter sort sequence: 150\\- For the Fld# that specify 'Employee Last Name', enter sort sequence: 200\\ \\All Sort sequences must be entered on entries with the same Record Number\\ \\Sort Sequence is not supported for XML file format because xml file may specify many different Record # to generate xml begin and end tags and the xml tags are not able to sort along with the data.\\ \\Sort Sequence is not supported if the IDIF format contains 'Pay Header Begin' or 'Pay Header Summary' because the Sorting of the Detail Record cannot carry it's associated Header/Summary Record
;Format Mask:Applicable to Numeric and Date field
;Record Type:Optional, may be used for this Interface Type\\ \\If Record Type is not specified, the following Record Number range are used:
||Record Number||Interface File Records generated
|0|Qualify Records
|1 - 29|Header Records
|30 - 69|Detail Records
| 70 - 99|Trailer Records\\ \\If Record Type is specified, lexicon X_RECORD_TYPE values are:
|00 - Not Specified|Not applicable for this Interface type
|01 - Header Record|Generate Header records at begin of file
|10 - Employer Header|Not used for UPPHF
|11 - Employer Summary|Not used for UPPHF
|12 - Employer Header 2|Not used for UPPHF
|13 - Employer Summary 2|Not used for UPPHF
|14 - Employee Header|Not used for UPPHF
|15 - Employee Summary|Not used for UPPHF
|16 - Pay Header Begin|Generate records at beginning of each Pay Header
|17 - Pay Header Summary|Generate records at the end of each Pay Header
|20 - Detail Record|Generate Pay Header interface records
|21 - Detail Level 1|Detail Level 1 is used for Journal Entries
|22 - Detail Level 2|Not used for UPPHF
|23 - Detail Level 3|Not used for UPPHF
|24 - Detail Level 4|Not used for UPPHF
|25 - Detail Level 5|Not used for UPPHF
|30 - Detail Summary|Not used for UPPHF
|80 - Total Record|Not used for UPPHF
|90 - Trailer Record|Generate Trailer records at end of file\\ \\May contain File totals, record counts etc
|91 - Qualify Record|Should be used for Record Number 0\\ \\The Qualify records are performed at the beginning of every Pay Header to qualify the Pay Header\\ \\You can use derivation expression to BYPASS certain criteria
|92 - Update Record|Should be defined at the end of the IDIF definition\\ \\In non-Trial mode, the UDF can be Inserted or Updated as defined in the Variable Name and Constant Value field\\ \\You can use derivation expression to BYPASS certain criteria for Update
;Record Identifier:Not used for this Interface Type
;Constant Value:If Variable Name = 'Constant Value', this field specifies the Constant Value to be used\\ \\If Variable Name = 'User Calc', this field specifies the User Calc Name\\ \\If Variable Name = 'UDF (xxx)', this field specifies the User Defined Field Name\\ \\If Variable Name = 'Statistics Amt', this field specifies the Statistics Code\\ \\If Variable Name = 'Element', this field specifies the Element Code\\ \\If Variable Name = 'Total Value', this field specifies the Rec# and Field # of the Detail Records to be totaled\\e.g. Record # 50 Field 70 is to be totaled and Total option = 'Calculate Total', then the Trailer record can report the 'Total Value', Constant value should be 5070
;Print Zero Rule:Applicable to Numeric field only, use for Record Type = 'Detail Record'\\ \\If amount is zero, this field indicates to include this amount in the interface file or not\\e.g. if the field is from 'Element Amount' and the amount is zero, the user may not want to report this amount.\\ \\If all numeric amounts are zero within one Record# and the Print Zero Rule are set to 'Do not Print zerosÃ' for each field, then this entry will not be reported on interface file.\\ \\Lexicon X_PRINT_ZERO_RULE
|00 | Not Specified
|01 | Print Zero Amounts
|02| Don't Print Zeros
;XML Tag option:Applicable to XML file, if Variable Name = 'XML begin Tag'or 'XML end Tag', this field option indicates if the XML Tag should be written.\\ \\Lexicon X_XML_TAG_OPTION
|00 | Not Specified
|01 | Optional, omit tag if null
|02| Mandatory, always write
;Accum Option:Applicable to Numeric field only, use for Record Type = 'Detail Record'\\ \\Indicate if this Record #, Field # amount should be accumulated or not\\e.g. if the field is a 'Pay Number' or 'Check Number', then do not accumulate.\\ \\If field is 'Element Value' or 'PC Amount', then you may want to accumulate to avoid writing too much detail per element or per pay component.
;Total Option:Applicable to Numeric field only, use for Record Type = Detail Record, Detail Leveln\\ \\Indicate if this Record #, Field # amount should be totaled for Header or Trailer record\\e.g. if the field is a 'FTE' or 'Rate of Pay', then do not totaled.\\ \\If field is 'Statistics Amount' or 'User Calc Amount', then you may want to calculate the total for Trailer record\\ \\Lexicon X_TOTAL_OPTION
|00 | Not Specified
|01 | Calculate Total
;Derivation Expression:Specifies the derivation expression for the Variable name.\\ \\This derivation expression will apply to the result of the Variable name before format mask.\\ \\The user may use RTRIM(~) to remove trailing blanks before comparing the entire string because the data may contain blanks that are not visible at the end.\\ \\Please refer to following Derivation Expression processing
At line 204 changed 2 lines
Record Number - user assigned Record Number
- each Record Number generates a new line in the interface file
!BYPASS Capability
On IDIF Derivation expression, user may decode the Variable Name using the ~ character and return the word 'BYPASS' to bypass the Detail record entry that are with certain criteria
At line 207 changed one line
The followings are suggested Record Numbers, user can set up their own numbers.
The 'BYPASS' criteria can be set up for Record Type = 'Qualify record', 'Detail record', and should not be used for Header and Trailer records
At line 209 changed 5 lines
Record Number Interface File Records generated
0 Qualify Records
1 – 29 Header Records
30 – 69 Detail Records
70 – 99 Trailer Records or Update Records
If the return value of any IDIF Record Number/Field Number = 'BYPASS', then this Detail record will be bypassed and will not be written to the Interface file
At line 215 changed 4 lines
Field Number - user assigned number
Name - user assigned field name
XML Tag - optional, used for XML File Format only
- if XML Tag is not specified for XML File, then the Name field is used as XML Tag
Example:
*To include only Departments start with 'P' on interface file:\\decode(rtrim(substr(~,1,1)),'P',~,'BYPASS')
*To include only Departments ends with 'C' on interface file:\\decode(substr(~,length(rtrim(~)),1),'C','BYPASS',~)
*To bypass Cost Centers that has '????' in second segments:\\decode(SUBSTR(~,5,4),'????','BYPASS',SUBSTR(~,5,4))
*To include Journal Entries with Account Numbers over 40000 in segment 5:\\decode(greatest('40000',substr(~,16,5)),'40000','BYPASS',substr(~,16,5))
At line 220 removed 129 lines
Beginning Position - if File Format = ‘Fixed Format’, the user must specify the Beginning position
Ending Position - if File Format = ‘Fixed Format’, the user must specify the Ending position
- these positions must be continuous without gap, otherwise an error situation will occur
- Beginning/Ending positions are not needed for xml and other file format
Field Type - indicate the result of the Field Variable is a type of ‘Char’, ‘Number’ or ‘Date’
Variable Name - select from lexicon X_INF_VARIABLE_NAME 32nnnn, refer to lexicon list above
Sort Sequence - specifies the Sort Sequence for this Record #, Field #
- use for Record # with Record Type = ‘Detail Record’ only
- for Record # with Record Type = ‘Detail Level 1’ to ‘Detail Level 5’, it uses the same Sort from Record Type = ‘Detail Record’ so that the Detail Level n records are followed after the ‘Detail Record’
e.g. Interface File need to sort by: Department, Employee First Name, Last Name
- then for the Fld# entry that specify ‘Department’, enter sort sequence: 100
- for the Fld# that specify ‘Employee First Name’, enter sort sequence: 150
- for the Fld# that specify ‘Employee Last Name’, enter sort sequence: 200
- all Sort sequences must be entered on entries with the same Record Number
- Sort Sequence is not supported for XML file format because xml file may specify many different Record # to generate xml begin and end tags and the xml tags are not able to sort along with the data
- Sort Sequence is not supported if the IDIF format contains ‘Pay Header Begin’ or ‘Pay Header Summary’ because the Sorting of the Detail Record cannot carry it’s associated Header/Summary Record
Format Mask - applicable to Numeric and Date field
Record Type - optional, may be used for this Interface Type
- if Record Type is not specified, the following Record Number range are used:
Record Number Interface File Records generated
0 Qualify Records
1 – 29 Header Records
30 – 69 Detail Records
70 – 99 Trailer Records
- if Record Type is specified, lexicon X_RECORD_TYPE values are:
00 – Not Specified - not applicable for this Interface type
01 – Header Record - generate Header records at begin of file
10 – Employer Header - not used for UPPHF
11 – Employer Summary - not used for UPPHF
12 – Employer Header 2 - not used for UPPHF
13 – Employer Summary 2 - not used for UPPHF
14 – Employee Header - not used for UPPHF
15 – Employee Summary - not used for UPPHF
16 – Pay Header Begin - generate records at beginning of each Pay Header
17 – Pay Header Summary - generate records at the end of each Pay Header
20 – Detail Record - generate Pay Header interface records
21 – Detail Level 1 - Detail Level 1 is used for Journal Entries
22 – Detail Level 2 - not used for UPPHF
23 – Detail Level 3 - not used for UPPHF
24 – Detail Level 4 - not used for UPPHF
25 – Detail Level 5 - not used for UPPHF
30 – Detail Summary - not used for UPPHF
80 – Total Record - not used for UPPHF
90 – Trailer Record - generate Trailer records at end of file
- may contain File totals, record counts etc
91 – Qualify Record - should be used for Record Number 0
- the Qualify records are performed at the beginning of every Pay Header to qualify the Pay Header
- user can use derivation expression to BYPASS certain criteria
92 – Update Record - should be defined at the end of the IDIF definition
- in non-Trial mode, the UDF can be Inserted or Updated as defined in the Variable Name and Constant Value field
- user can use derivation expression to BYPASS certain criteria for Update
Record Identifier - not used for this Interface Type
Constant Value - if Variable Name = ‘Constant Value’, this field specifies the Constant Value to be used
- if Variable Name = ‘User Calc’, this field specifies the User Calc Name
- if Variable Name = ‘UDF (xxx)’, this field specifies the User Defined Field Name
- if Variable Name = ‘Statistics Amt’, this field specifies the Statistics Code
- if Variable Name = ‘Element’, this field specifies the Element Code
- if Variable Name = ‘Total Value’, this field specifies the Rec# and Field # of the Detail Records to be totaled
e.g. Record # 50 Field 70 is to be totaled and Total option = ‘Calculate Total’, then the Trailer record can report the ‘Total Value’, Constant value should be 5070
Print Zero Rule - applicable to Numeric field only, use for Record Type = ‘Detail Record’
- if amount is zero, this field indicates to include this amount in the interface file or not
- e.g. if the field is from ‘Element Amount’ and the amount is zero, the user may not want to report this amount
- if all numeric amounts are zero within one Record# and the Print Zero Rule are set to ‘Do not Print zeros’ for each field, then this entry will not be reported on interface file
- lexicon X_PRINT_ZERO_RULE
00 – Not Specified
01 – Print Zero Amounts
02 – Don’t Print Zeros
XML Tag option - applicable to XML file, if Variable Name = ‘XML begin Tag’or ‘XML end Tag’, this field option indicates if the XML Tag should be written
- lexicon X_XML_TAG_OPTION
00 – Not Specified
01 – Optional, omit tag if null
02 – Mandatory, always write
Accum Option - applicable to Numeric field only, use for Record Type = ‘Detail Record’
- indicate if this Record #, Field # amount should be accumulated or not
- e.g. if the field is a ‘Pay Number’ or ‘Check Number’, then do not accumulate
- if field is ‘Element Value’ or ‘PC Amount’, then you may want to accumulate to avoid writing too much detail per element or per pay component
Total Option - applicable to Numeric field only, use for Record Type = Detail Record, Detail Leveln
- indicate if this Record #, Field # amount should be totaled for Header or Trailer record
- e.g. if the field is a ‘FTE’ or ‘Rate of Pay’, then do not totaled
- if field is ‘Statistics Amount’ or ‘User Calc Amount’, then you may want to calculate the total for Trailer record
- lexicon X_TOTAL_OPTION
00 – Not Specified
01 – Calculate Total
Derivation Expression - specifies the derivation expression for the Variable name
- this derivation expression will apply to the result of the Variable name before format mask
- the user may use RTRIM(~) to remove trailing blanks before comparing the entire string because the data may contain blanks that are not visible at the end
- please refer to following Derivation Expression processing
!BYPASS capability
- on IDIF Derivation expression, user may decode the Variable Name using the ~ character and return the word ‘BYPASS’ to bypass the Detail record entry that are with certain criteria
- the ‘BYPASS’ criteria can be set up for Record Type = ‘Qualify record’, ‘Detail record’, and should not be used for Header and Trailer records
- if the return value of any IDIF Record Number/Field Number = ‘BYPASS’, then this Detail record will be bypassed and will not be written to the Interface file
- Example:
- to include only Departments start with ‘P’ on interface file:
decode(rtrim(substr(~,1,1)),'P',~,'BYPASS')
- to include only Departments ends with ‘C’ on interface file:
decode(substr(~,length(rtrim(~)),1),'C','BYPASS',~)
- to bypass Cost Centers that has ‘????’ in second segments:
decode(SUBSTR(~,5,4),'????','BYPASS',SUBSTR(~,5,4))
- to include Journal Entries with Account Numbers over 40000 in segment 5:
decode(greatest('40000',substr(~,16,5)),'40000','BYPASS',substr(~,16,5))
At line 351 changed one line
- when UPPHF is run with Interface Level = ‘Pay Headers + Pay Lines’, user may want to BYPASS the current Pay Line and continue to process the next Pay Line
When UPPHF is run with Interface Level = 'Pay Headers + Pay Lines', you may want to BYPASS the current pay line and continue to process the next pay line.
At line 353 changed one line
- when a Pay Line (ppl) is being processed, all the associated Pay Line Details (ppld) are processed one at a time until all ppld are finished
When a Pay Line (ppl) is being processed, all the associated Pay Line Details (ppld) are processed one at a time until all ppld are finished.
At line 355 changed one line
- the following BYPASS capabilities are available at the Pay Line level:
The following BYPASS capabilities are available at the Pay Line level:
;BYPASS:Bypass current ppld, will go to process next ppld\\ \\Usually BYPASS should be used for Qualify Records and is also used for other Record Types, this BYPASS also works in ppl
;BYPASS-1-PPL:Bypass current ppld, will go to process next ppld\\ \\When Interface Level = 'Pay Headers + Pay Lines', you should use 'BYPASS-1-PPL' instead of just 'BYPASS' for clarification
;BYPASS-ALL-PPL:Bypass all ppl and ppld from this point onward, will go to process Pay Amounts\\ \\The Pay Amounts will subtract the amounts that have been processed by ppld so far
;BYPASS-TO-PPL:Bypass all ppl, ppld, Pay Amounts from this point onward\\ \\Will go to process Pay Header Summary\\ \\Example:\\[UPPHF_01.JPG]\\ \\In Derivation Expression:\\decode(~,'14-OCT-2008','BYPASS','16-OCT-2008','GOTO#60#1','22-OCT-2008','BYPASS-1-PPL','24-OCT-2008','BYPASS-ALL-PPL',~)\\ \\This means DECODE the Pay Line Start Date, if the Pay Line Start Date:
#equals to '14-OCT-2008', then return the value of 'BYPASS'
#equals to '16-OCT-2008', then return the value of 'GOTO#60#1'- this will GOTO Rec# 60 Field # 1
#equals to '22-OCT-2008', then return the value of 'BYPASS-1-PPL'
#equals to '24-OCT-2008', then return the value of 'BYPASS-ALL-PPL'
At line 357 removed 30 lines
BYPASS - bypass current ppld, will go to process next ppld
- usually BYPASS should be used for Qualify Records and is also used for other Record Types, this BYPASS also works in ppl
BYPASS-1-PPL - bypass current ppld, will go to process next ppld
- when Interface Level = ‘Pay Headers + Pay Lines’, user should use ‘BYPASS-1-PPL’ instead of just ‘BYPASS’ for clarification
BYPASS-ALL-PPL - bypass all ppl and ppld from this point onward, will go to process Pay Amounts
- the Pay Amounts will subtract the amounts that have been processed by ppld so far
BYPASS-TO-PPL - bypass all ppl, ppld, Pay Amounts from this point onward
- will go to process Pay Header Summary
Example:
In Derivation Expression:
decode(~,'14-OCT-2008','BYPASS','16-OCT-2008','GOTO#60#1','22-OCT-2008','BYPASS-1-PPL','24-OCT-2008','BYPASS-ALL-PPL',~)
- this means DECODE the Pay Line Start Date, if the Pay Line Start Date:
1) equals to ‘14-OCT-2008’, then return the value of ‘BYPASS’
2) equals to ‘16-OCT-2008’, then return the value of 'GOTO#60#1' - this will GOTO Rec# 60 Field # 1
3) equals to ‘22-OCT-2008’, then return the value of ‘BYPASS-1-PPL’
4) equals to ‘24-OCT-2008’, then return the value of ‘BYPASS-ALL-PPL’
At line 124 added one line
When processing IDIF records of the same Record Type (e.g. Detail Record), you may want to skip some Record # Field # based on certain criteria and resume processing of the same Record Type at a later Record# Field# onward.
At line 126 added one line
The following GOTO capabilities are available for all Record Types in Derivation Expression:\\GOTO#nn#nnn - where the 1st nn is the Record #, the 2nd nnn is the Field #
At line 390 changed one line
- when processing IDIF records of the same Record Type (e.g. Detail Record), the user may want to skip some Record # Field # based on certain criteria and resume processing of the same Record Type at a later Record# Field# onward
Since the IDIF entries are processed in chronological order, GOTO#nn#nnn must be for a Record# Field# that is after the current Record# Field#
At line 392 changed one line
- the following GOTO capabilities are available for all Record Types in Derivation Expression:
If an incorrect GOTO#nn#nnn is specified, or the #nn#nnn is NOT for the same Record Type, or if it is for a previous Rec# Field#, an exception message will be issued, the GOTO statement cannot be executed after skipping the records, you must verify the Interface File from this point onward
At line 394 changed one line
GOTO#nn#nnn - where the 1st nn is the Record #, the 2nd nnn is the Field #
Multiple GOTO#nn#nnn can be used within the same Record Type
At line 396 changed one line
- since the IDIF entries are processed in chronological order, GOTO#nn#nnn must be for a Record# Field# that is after the current Record# Field#
Please see the above example for BYPASS-1-PPL that contains GOTO#60#1 to go to Record# 60 Field# 1
At line 398 changed one line
- if an incorrect GOTO#nn#nnn is specified, or the #nn#nnn is NOT for the same Record Type, or if it is for a previous Rec# Field#, an exception message will be issued, the GOTO statement cannot be executed after skipping the records, the user must verify the Interface File from this point onward
If an Invalid GOTO is encountered in IDIF definition, the Trial mode parameter is set to 'Y' in order to prevent the Updating of the User Defined Fields from the Record Type '92-Update Record'.
At line 400 changed one line
- multiple GOTO#nn#nnn can be used within the same Record Type
For XML File Format, the GOTO#nn#nnn can be used to skip certain XML Tags and carry on the processing
At line 402 changed one line
- please see the above example for BYPASS-1-PPL that contains GOTO#60#1 to go to Record# 60 Field# 1
For Fixed File Format, if the GOTO#nn#nnn is for the current Record#, it will GOTO the specified #nn#nnn, the current Record# information will be written
At line 404 changed one line
- if an Invalid GOTO is encountered in IDIF definition, the Trial mode parameter is set to ‘Y’ in order to prevent the Updating of the User Defined Fields from the Record Type ’92-Update Record’
For Fixed File Format, if the GOTO#nn#nnn is for a different Record#, it will GOTO the specified #nn#nnn of the different Record#, the current Record# information will NOT be written
At line 406 changed 6 lines
- for XML File Format, the GOTO#nn#nnn can be used to skip certain XML Tags and carry on the processing
- for Fixed File Format, if the GOTO#nn#nnn is for the current Record#, it will GOTO the specified #nn#nnn, the current Record# information will be written
- for Fixed File Format, if the GOTO#nn#nnn is for a different Record#, it will GOTO the specified #nn#nnn of the different Record#, the current Record# information will NOT be written
e.g. UEEF IDIF Record# 30 Field # 45, decode Plan_Code, if it equals to 'HL GROUP LIFE', GOTO#35#10\\This will skip the entire Record# 30 and carry on from Record# 35 Field#10 for the fixed file format.
[UPPHF_02.JPG]
At line 147 added 2 lines
!Multiple Fields Processing
[UPPHF_03.JPG]
At line 414 changed 2 lines
- e.g. UEEF IDIF Record# 30 Field # 45, decode Plan_Code, if it equals to ‘HL GROUP LIFE’, GOTO#35#10
- this will skip the entire Record# 30 and carry on from Record# 35 Field#10 for the fixed file format
On IDIF derivation expression, user can specify multiple variable names processing by indicating the lexicon value of the X_INF_VARIABLE_NAME inside the bracket [ ], e.g. [320001]
At line 417 changed 2 lines
!Multiple Fields processing
Lexicon values available from IMLN for X_INF_VARIABLE_NAME are: 32nnnn, 35nnnn
At line 420 changed one line
- on IDIF derivation expression, user can specify multiple variable names processing by indicating the lexicon value of the X_INF_VARIABLE_NAME inside the bracket [ ], e.g. [320001]
This provides the full list of INF variables interchangeably for UPPHF, UEEF as long as the Database tables are being loaded according to the Interface Level parameter of the run
At line 422 changed one line
- lexicon values available from IMLN for X_INF_VARIABLE_NAME are: 32nnnn, 35nnnn
Please see example below:
At line 424 changed one line
- this provides the full list of INF variables interchangeably for UPPHF, UEEF as long as the Database tables are being loaded according to the Interface Level parameter of the run
__Example: Record # 50, Field # 20 Requirement for Employee Row id or Unit id:__
At line 426 changed one line
- please see example below
If Pay Header Group User Defined Field (UDF) 'PROJECT HOURS BY PERSON' is 'Y', this means the employee is an 'ADMIN' employee, then if the Journal Entry is reporting for 'Hours', then use the Identities eid.id on the interface file field, otherwise, use the Unit dun.id on the field for all other situation
At line 162 added one line
From above IDIF set up, you should specify the Variable Name using 'UDF (DGD)' and enter the UDF name in Constant Value field, then the value of UDF will be returned and represented as ~ in the derivation expression.
At line 429 changed one line
In derivation expression, enter:\\decode(~,'Y',decode([320803],'02',[320009],[350400]),[350400])\\where:
|[320803]|Journal Type (DGA), 01 - Financial Journal, 02 - Statistical Journal
|[320009]|Identity eid_id
|[350400]|Unit dun_id (DUN)
This derivation expression means:
*decode the value of ~ from UDF
**if the value = 'Y', then
***decode the value from [320803] Journal Type
****if Journal Type = '02' Statistical Journal, then
*****return [320009] Identify eid.id
****otherwise
*****return [350400] Unit dun_id
**otherwise
***return [350400] Unit dun_id
At line 431 changed one line
Example: Record # 50, Field # 20 Requirement for Employee Row id or Unit id:
__Example: Record # 50, Field # 10 Requirement: Work Date or Pay Period__
At line 433 changed one line
- if Pay Header Group User Defined Field (UDF) ‘PROJECT HOURS BY PERSON’ is ‘Y’, this means the employee is an ‘ADMIN’ employee, then if the Journal Entry is reporting for ‘Hours’, then use the Identities eid.id on the interface file field, otherwise, use the Unit dun.id on the field for all other situation
If Pay Header Group User Defined Field (UDF) 'PROJECT HOURS BY PERSON' is 'Y', this means the employee is an 'ADMIN' employee, then use the Pay Period on the interface file field, otherwise use the GL Effective date on the interface file field
At line 435 changed one line
- from above IDIF set up, user should specify the Variable Name using ‘UDF (DGD)’ and enter the UDF name in Constant Value field, then the value of UDF will be returned and represented as ~ in the derivation expression
From above IDIF set up, user should specify the Variable Name using 'UDF (DGD)' and enter the UDF name in Constant Value field, then the value of UDF will be returned and represented as ~ in the derivation expression.
At line 437 changed one line
- in derivation expression, enter:
In derivation expression, enter:\\decode(~,'Y',[320102],to_char(to_date([320756]),'DD/MM/YYYY'))\\where:
|[320102]|Pay Period
|[320756]|GL Eff Date (PJD)
At line 439 changed one line
decode(~,'Y',decode([320803],'02',[320009],[350400]),[350400])
This derivation expression means:
*decode the value of ~ from UDF
**if the value = 'Y', then
***return the value from [320102] Pay Period
**otherwise
***return the value from [320756] GL Effective date with the date format of 'DD/MM/YYYY'
At line 441 removed 39 lines
where:
[320803] - Journal Type (DGA), 01 – Financial Journal, 02 – Statistical Journal
[320009] - Identity eid_id
[350400] - Unit dun_id (DUN)
- this derivation expression means:
- decode the value of ~ from UDF
- if the value = ‘Y’, then
- decode the value from [320803] Journal Type
- if Journal Type = ‘02’ Statistical Journal, then
- return [320009] Identify eid.id
- otherwise
- return [350400] Unit dun_id
- otherwise
- return [350400] Unit dun_id
Example: Record # 50, Field # 10 Requirement: Work Date or Pay Period
- if Pay Header Group User Defined Field (UDF) ‘PROJECT HOURS BY PERSON’ is ‘Y’, this means the employee is an ‘ADMIN’ employee, then use the Pay Period on the interface file field, otherwise use the GL Effective date on the interface file field
- from above IDIF set up, user should specify the Variable Name using ‘UDF (DGD)’ and enter the UDF name in Constant Value field, then the value of UDF will be returned and represented as ~ in the derivation expression
- in derivation expression, enter:
decode(~,'Y',[320102],to_char(to_date([320756]),'DD/MM/YYYY'))
where:
[320102] - Pay Period
[320756] - GL Eff Date (PJD)
- this derivation expression means:
- decode the value of ~ from UDF
- if the value = ‘Y’, then
- return the value from [320102] Pay Period
- otherwise
- return the value from [320756] GL Effective date with the date format of ‘DD/MM/YYYY’
At line 482 changed one line
The user has ability to call some P2K internal functions in the derivation expression under the guidance of HL consultant. The following example is for UPPHF Payroll History Interface, and is used to demonstrate Derivation Expression only. In this example, the Element value of ‘HOURS COMP TIME’ will be returned for Variable Name ‘Pay Header pph_id’.
The user has ability to call some P2K internal functions in the derivation expression under the guidance of HL consultant. The following example is for UPPHF Payroll History Interface, and is used to demonstrate Derivation Expression only. In this example, the Element value of 'HOURS COMP TIME' will be returned for Variable Name 'Pay Header pph_id'.
At line 484 changed one line
Note: the IDIF screen layout is revised as above, the screen prints in this section are example of Derivation Expression only and therefore are not matched with revised layout above, please ignore the layout format
%%information The IDIF screen layout is revised as above, the screen prints in this section are example of Derivation Expression only and therefore are not matched with revised layout above, please ignore the layout format.%%
At line 486 changed one line
[UPPHF_04.JPG]
At line 204 added one line
The above example can also be achieved by setting up Variable Name = ‘Element pph Value’ with the Element Code specified in the Constant Value field.
At line 206 added one line
[UPPHF_05.JPG]
At line 490 changed one line
The above example can also be achieved by setting up Variable Name = ‘Element pph Value’ with the Element Code specified in the Constant Value field.
!P2K Internal Functions with Parameters
At line 492 changed one line
The user has ability to call some internal functions in the derivation expression under the guidance of a consultant and pass the following internal parameters in order to perform some internal calculation:
At line 212 added 3 lines
|#PPH_ID#|- must be capital letters, this #PPH_ID# will be replaced by the current Pay Header's pph.id
|#EEM_ID#|- must be capital letters, this #EEM_ID# will be replaced by the current Employment's eem.id
|#EID_ID#|- must be capital letters, this #EID_ID# will be replaced by the current Identity's eid.id
At line 216 added one line
e.g. the Element PC value of 'HOURS O/T' will be retrieved first and is represented as ~ in derivation expression
At line 218 added one line
The derivation expression will return the Element value of 'HOURS COMP TIME' for #PPH_ID# and add to value of ~
At line 220 added one line
[UPPHF_06.JPG]
At line 498 changed one line
!P2K Internal Functions with Parameters
User may perform some internal arithmetic calculation in the derivation expression to return some prorated amount.
At line 224 added one line
((Value of a PC in 'HOURS OT' element / Value of 'HOURS OT' Element)* Benefit Element 'HOURS COMP TIME')
At line 501 changed one line
The user has ability to call some P2K internal functions in the derivation expression under the guidance of HL consultant and pass the following internal parameters in order to perform some internal calculation:
[UPPHF_07.JPG]
At line 503 changed 3 lines
#PPH_ID# - must be capital letters, this #PPH_ID# will be replaced by the current Pay Header’s pph.id
#EEM_ID# - must be capital letters, this #EEM_ID# will be replaced by the current Employment’s eem.id
#EID_ID# - must be capital letters, this #EID_ID# will be replaced by the current Identity’s eid.id
!XML File format
At line 507 changed 2 lines
e.g.. the Element PC value of ‘HOURS O/T’ will be retrieved first and is represented as ~ in derivation expression
- the derivation expression will return the Element value of ‘HOURS COMP TIME’ for #PPH_ID# and add to value of ~
[UPPHF_08.JPG]
At line 510 changed one line
The system provides starter_IDIF_HL$PAY-HIST-XML.sql script to load in example of a xml format interface file.
At line 234 added one line
You should use (Copy Definition) to copy into a different Interface Code and then enter their own company data.
At line 513 changed one line
User may perform some internal arithmetic calculation in the derivation expression to return some prorated amount.
Please refer to IDIF Fixed File Format for details of field description.
At line 515 changed 2 lines
Value of a PC in ‘HOURS O/T’ element * Benefit Element ‘HOURS COMP TIME’
Value of ‘HOURS O/T’ Element
The Beginning and Ending positions are not needed for xml file format.
At line 518 changed one line
!!IDIF - Call User Calc
!Call User Calc Function
At line 243 added one line
You can call User Calc function at each Record Number, each Field Number
At line 521 changed one line
!XML File format
You should set up Variable Name = 'User Calc', and specify the User Calc name in the Constant Value field
At line 523 changed 4 lines
- the system provides starter_IDIF_HL$PAY-HIST-XML.sql script to load in example of a xml format interface file
- the user should use [Copy Definition] to copy into a different Interface Code and then enter their own company data
- please refer to IDIF Fixed File Format for details of field description
- the Beginning and Ending positions are not needed for xml file format
The Field Type must be defined with Char, Number or Date, the User Calc function on IMUC screen Return Value must match the values (Char, Number or Date) with the IMUC RET command to return the corresponding Char, Number or Date
At line 249 added 3 lines
The data base tables available for User Calc are:
at company level: DEN/DLN/DDP/DDD/DUN/DGR/DGD/DGV
at employee level: EID/EPS/EEM/EAS/EASD/PPRU/PPRC
At line 529 changed 3 lines
!!IDIF – Call User Calc
!Call User Calc function
!!IDIF - Update Record Set Up
During the UPPHF run, you have the ability to update certain User Defined Fields (UDF) to indicate that the Interface file has been generated and mark the records as being processed. You may reference these UDFs in [IDIF] to prevent the same information from being processed again.
At line 533 changed 3 lines
- the user can call User Calc function at each Record Number, each Field Number
- the user should set up Variable Name = ‘User Calc’, and specify the User Calc name in the Constant Value field
- the Field Type must be defined with Char, Number or Date, the User Calc function on IMUC screen Return Value must match the values (Char, Number or Date) with the IMUC RET command to return the corresponding Char, Number or Date
You can also update the [File Creation Number|FILE_CREATION_NUMBER] on an Update Record indicating that variable and the derivation expression to {{{~ + 1}}}
At line 537 changed 3 lines
- the data base tables available for User Calc are:
at company level: DEN/DLN/DDP/DDD/DUN/DGR/DGD/DGV
at employee level: EID/EPS/EEM/EAS/EASD/PPRU/PPRC
On the [IDIF] screen, Record Type '92-Update Record' should be defined at the end of the [IDIF] definition
At line 541 removed 2 lines
!!IDIF - Update Record Set Up
During the UPPHF run, you have the ability to update certain User Defined Fields (UDF) to indicate that the Interface file has been generated and mark the records as being processed.
At line 544 changed one line
You may reference these UDFs in [IDIF] to prevent the same information from being processed again.
The Variable Name should contain the UDF (xxx) that is to be updated or inserted,e.g. '320629 - UDF (PRN) (32)'
At line 546 removed 3 lines
On the [IDIF] screen, Record Type '92-Update Record' should be defined at the end of the [IDIF] definition
* the Variable Name should contain the UDF (xxx) that is to be updated or inserted,e.g. '320629 - UDF (PRN) (32)'
At line 551 changed one line
The Derivation Expression field should contain the expression that is evaluated to the value to be updated for the UDF
The Derivation Expression field should contain the expression that is evaluated to the value to be updated for the UDF.
At line 554 changed one line
* multiple fields processing, DECODE, BYPASS, string manipulation, concatenation, function calls, etc.
*Multiple fields processing
*DECODE
*BYPASS
*String manipulation
*Concatenation
*Function calls, etc.
At line 565 changed one line
If the UDF is for a variable name that can be varied at the Pay Line level, then the UDF will be updated at each Pay Line level, e.g. 'UDF (DDD)', each pay line may point to a different department, therefore the UDF may be updated at the Pay Line level for that department
If the UDF is for a variable name that can be varied at the Pay Line level, then the UDF will be updated at each Pay Line level, e.g. 'UDF (DDD)', each pay line may point to a different department, therefore the UDF may be updated at the Pay Line level for that department.
At line 567 changed one line
Using the Returned Value of the derivation expression, UPPHF finds if the UDF already exists; if the UDF exists and the new value is different than the existed UDF value, it will be updated; if the UDF does not exist, it will be inserted
Using the Returned Value of the derivation expression, UPPHF finds if the UDF already exists:
*if the UDF exists and the new value is different than the existed UDF value, it will be updated
*if the UDF does not exist, it will be inserted
At line 583 changed one line
After UDFs are updated or inserted in UPPHF, the number of records updated for each Data Base table will be displayed on the UPPHF report
After UDFs are updated or inserted in UPPHF, the number of records updated for each Data Base table will be displayed on the UPPHF report.
At line 587 removed 52 lines
!!IDIF – Update Record
!IDIF – Update Record Set Up
- During the UPPHF run, user has ability to Update certain User Defined Fields (UDF) to indicate the Interface File has been generated and mark the records as being processed. User may reference these UDFs in IDIF to prevent the same information from being processed again.
- on IDIF screen, Record Type ’92-Update Record’ should be defined at the end of the IDIF definition
- the Variable Name should contain the UDF (xxx) that is to be Updated or Inserted, e.g. ‘320629 – UDF (PRN) (32)’
- the Constant Value field should contain the Name of the UDF, e.g UPPHF_CALPERS_PRN
- if this UDF name does not exist on the IMUF screen, UPPHF will create the UDF with this name on IMUF screen for the Data Base Table to be updated
- the Derivation Expression field should contain the Expression that is evaluated to the Value to be updated for the UDF
- the following Derivation Expression features can be used to derive the Value to be updated:
- multiple fields processing, DECODE, BYPASS, String manipulation, concatenation, function calls etc
- when UPPHF is run in non-Trial mode, Record Type ’92-Update Record’ will be processed at the appropriate levels to check if the UDF should be updated for the associated Data Base Tables
From above Example:
- Rec#500 Field#10 indicates to update ‘UDF (PRN)’, this will be processed at the end of each qualified Pay Run
- Rec#500 Field#20 indicates to update ‘UDF (PPH)’, this will be processed at the end of each qualified Pay Header
- Rec#500 Field#30 indicates to update ‘UDF (PPL)’, this will be processed at the end of each qualified Pay Line
- Rec#500 Field#40 indicates to update ‘UDF (EEM)’, this will be processed at the end of each qualified Pay Header
- Rec#500 Field#50 indicates to update ‘UDF (EASD)’, this will be processed at the end of each qualified Pay Line
- if the UDF is for a Variable Name that can be varied at the Pay Line level, then the UDF will be updated at each Pay Line level, e.g. ‘UDF (DDD)’, each Pay Line may point to a different Department, therefore the UDF may be updated at the Pay Line level for that Department
- using the Returned Value of the Derivation Expression, UPPHF finds if the UDF already exists; if the UDF exists and the new value is different than the existed UDF value, it will be Updated; if the UDF does not exist, it will be Inserted
- list of UDF supported in UPPHF from X_INF_VARIABLE_NAME are:
320606 – UDF (EID) (32)
320607 – UDF (EEM) (32)
320608 – UDF (EPS) (32)
320610 – UDF (EASD) (32)
320621 – UDF (DED) (32)
320623 – UDF (DDD) (32)
320624 – UDF (DLN) (32)
320626 – UDF (DUD) (32)
320628 – UDF (DGD) (32)
320629 – UDF (PRN) (32)
320630 – UDF (PPH) (32)
320631 – UDF (PPL) (32)
- after UDFs are Updated or Inserted in UPPHF, the Number of Records Updated for each Data Base Table will be displayed on the UPPHF report
- note that these Number of UDF Updated represents the number of times the Tables are being touched, these may not necessarily be the exact or unique number of UDF for that Table, e.g. UDF (EEM) may be touched 2 times if an employee has 2 Pay Headers to update the same EEM but with a different Value
At line 644 changed one line
A pay run's Pay Period End date or Pay Issue date must be on the day of or prior to the user specified ‘As of’ date.
A pay run's Pay Period End date or Pay Issue date must be on the day of or prior to the user specified 'As of' date.
At line 326 added 9 lines
!Pay Header Begin
After Pay Header is qualified, UPPHF will process IDIF Record Type ’16-Pay Header Begin’ to generate Pay Header related information for this Pay Header
Then the Interface Level parameter is checked for next set of processing.\\Lexicon X_INTERFACE_UPPHF values are:
|01 |Pay Headers
|02 | Pay Headers + Pay Lines
|10 |Journal Entries
At line 726 changed one line
__Record Type__: Interface File Record
||Record Type||Interface File Record
|Detail Record|This is an optional field and may generate a Header record for the pay header.
|Detail Level 1|This is a mandatory field and will generate one entry per Journal Detail record.
At line 728 changed 3 lines
__Detail Record__: This is an optional field and may generate a Header record for the pay header.
__Detail Level 1__: This is a mandatory field and will generate one entry per Journal Detail record. In this way you may generate interface records in following sequence:
In this way you may generate interface records in following sequence:
;:''....
At line 735 changed one line
;:''....
At line 741 changed one line
;:.'' etc''
;:.''....etc''
At line 746 changed one line
After the interface level is processed for these levels and before writing to the Interface File, UPPHF will process [IDIF] Record Type '17-Pay Header Summary' to generate pay header related summary information for this pay header.
After the interface level is processed for these levels.
Lexicon X_INTERFACE_UPPHF values are:
|01|Pay Headers
|02|Pay Headers + Pay Lines
|10|Journal Entries
At line 431 added 2 lines
Before writing to the Interface File, UPPHF will process [IDIF] Record Type '17-Pay Header Summary' to generate pay header related summary information for this pay header.
At line 755 changed 10 lines
|From Pay Period |This is an optional field. You may select a From Pay period for the Payroll code specified.
|To Pay Period |This is an optional field. You may select a To Pay period for the Payroll code specified.
|From Pay Issue Date| This is an optional field. You may select a From Pay Issue date for the pay headers.
|To Pay Issue Date |This is an optional field. You may select a To Pay Issue date for the pay headers. If the From-To Pay Issue dates are entered, each pay header's Pay Issue date must be within this date range in order to be processed.
|As Of| This date is used to retrieve pay runs that are with the Pay Period end date or Pay Issue Date that is on or prior to this As Of date.
|Interface Format Code| Select Interface Format Code that is with the Interface Type of '32-Pay History Interface'
|Interface Level| This is a mandatory field. Specify the level of Interface file to be produced.
|Directory Name| Enter a valid directory name for interface file.
|File Name |Enter the file name of the interface file. If the word 'mex' is specified in the file name, then it will be replaced with the current execution id of UPPHF run. For a fixed format file, you may specify a file with extension .txt. For a comma delimited format file, you may specify a file with extension .csv For the XML file, you may specify a file with extension .XML
|Exception Level| If the exception level is '0', only exception messages will be printed. If the exception level is '1', one line will be printed per pay header with performance time. If the exception level is '2', one line will be printed per pay header with performance time and one line per Detail Level 1 record. If the exception level is '8' or '9', full utility trace is available only if the user selects by Person code. Otherwise UPPHF will internally reset to exception level '1' due to the volume of trace messages.
|From Pay Period/To Pay Period |Optional ,Date, LOV Available\\You may select the From and To Pay period for the Payroll code specified.
|From / To Pay Issue Date|Optional ,Date, LOV Available\\You may select a From and To Pay Issue date for the pay headers.\\If the From-To Pay Issue dates are entered, each pay header's Pay Issue date must be within this date range in order to be processed.
|As Of|Mandatory, Date, LOV Available\\ This date is used to retrieve pay runs that are with the Pay Period end date or Pay Issue Date that is on or prior to this As Of date.
|Trial Run|Optional, [Yes or No|X_YES_NO] lexicon available\\You may indicate if the UDFs are to be updated for the UPPHF run.\\To run in non-Trial mode (Update mode), you should define IDIF Record Type '92-Update Record' to update UDFs.
|Interface Format Code|Optional, Text\\Select the Interface Format code (IDIF) that is with the Interface Type of '32-Pay History Interface'
|Interface Level|Mandatory,[Interface Level|X_INTERFACE_LEVEL] lexicon available\\Specify the level for the Interface file to be produced.
|Directory Name|Optional, Text\\Enter a valid directory name for interface file.
|File Name |Optional, Text\\Enter the file name of the interface file. If not provided, the file name will be taken from the IDIF definition.\\If you use the tokens ''MEX'' or ''DATE'' or ''TIME'' these will be replaced as noted in [P2K_PU.FILE_NAME].\\For a fixed format file, you may specify a file with extension .txt.\\For a comma delimited format file, you may specify a file with extension .csv\\For the XML file, you may specify a file with extension .XML
|Write Append to File|Mandatory,[Write Append|X_WRITE_APPEND] lexicon available\\Provides the option to write a file or append to an existing one.
|Exception Level|Optional, [Exception Level|X_TRACE_LEVEL] lexicon available\\This field defines the exception level (report messages) required.\\If the exception level is '0', only exception messages will be printed.\\If the exception level is '1', one line will be printed per pay header with performance time.\\If the exception level is '2', one line will be printed per pay header with performance time and one line per Detail Level 1 record.\\If the exception level is '8' or '9', full utility trace is available only if the user selects by Person code. Otherwise UPPHF will internally reset to exception level '1' due to the volume of trace messages.
|User Comments |Optional, Text \\This field holds the user-supplied comment which will appear in the header of all pages of the report. This is useful during testing phases to identify similar reports from each other.
At line 766 removed one line
At line 776 changed one line
|Payroll| This is a mandatory field. You must enter one 'Payroll Code' to be processed. The pay headers must belong to this payroll code in order to be processed.
|Payroll| This is an optional field. Multiple 'Payroll Code' filters are allowed to be entered.
At line 465 added 174 lines
!!Pay History (UPPHF) Default Variables
[X_INF_VARIABLE_NAME] is a [fixed lexicon]. Variables starting with "32" are used to define interfaces in the [IDIF] screen that will be created by the [UPPHF] program. These values will appear in the "Variable" field as selection options.\\
\\
%%zebra-table
||Saved\\Value||Displayed Value||Source of Data||Comments
| 320001 | Execution ID (32) | From Execution ID of the UPPHF run|
| 320002 | XML Tag (32) | |Indicates this Rec#/Fld# is for XML tag. You should enter the XML tag in the XML tag field, if XML tag field is not specified, the field name is used as XML tag e.g. <Request> or </Request> as XML tag. You should use one of the following ways to define XML tags: 1) use 320002-XML tag for all Begin and End tags i.e. you specify <Request> and </Request> 2) use 320604-XML Begin tag and 320605-XML End tag. This allows you to use XML tag option to indicate if the XML tag is mandatory or optional. You must not use 320002-XML tag to mix with 320604/320605 definition
| 320003 | Constant Value (32) | |You should specify the Constant to be used in [IDIF] Constant Value field
| 320004 | System Date/Time (32) | The current system date and time with following, select:to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')|You can use derivation expression SUBSTR to retrieve Date Only or Time Only
| 320005 | From Pay Period (32) | This field holds the earliest pay period that have been processed from all pay headers| This can be used for Header or Trailer record
| 320006 | To Pay Period (32) | This field holds the latest pay period that have been processed from all pay headers|This can be used for Header or Trailer record
| 320007 | Pay Header pph_id (32) | This field holds the id of the current pay header|This can be used in the derivation expression to call some internal Personality functions that needed the pph.id e.g. call Element function to return the value of an element: To retrieve the value of Element 'HOURS COMP TIME'. In Record# 50, Field#20, Variable Name = 'Pay Header [PPH_ID]', then in derivation expression: P2K_PPAMTS.SPELPAY(~,P2K_PPAMTS.SPGETPEL('HOURS COMP TIME'))
| 320008 | Employment eem_id (32) | This field holds the id of the current employment record, from [P2K_HR_EMPLOYMENTS]|
| 320009 | Identity eid_id (32) | This field holds the id of the current identity record from [P2K_HR_IDENTITIES]|This can be used in the derivation expression to call some internal Personality functions that needed the [EID_ID]
| 320010 | Person Code (32) | From [P2K_HR_IDENTITIES], [person_code|PERSON_CODE]|
| 320011 | First Name (32) | From [P2K_HR_IDENTITIES], [first_name|FIRST_NAME]|
| 320012 | Last Name (32) | From [P2K_HR_IDENTITIES], [last_name|LAST_NAME]|
| 320013 | First,Last Name (32) |From [P2K_HR_IDENTITIES], [first_name|FIRST_NAME] ', ' [last_name|LAST_NAME] |
| 320014 | Last,First Name (32) | From [P2K_HR_IDENTITIES], [last_name|FIRST_NAME] ', ' [first_name|FIRST_NAME]|
| 320015 | Trial Run (32) | From parameter P_TRIAL (Trial Run)|The value of 'Y' or 'N' is always returned in P_TRIAL. If NULL is entered, P_TRIAL is set to 'N'
| 320020 | Batch Number (32) | From [P2K_PR_BATCHES], [batch_number|BATCH_NUMBER]|
| 320030 | Pay Run Number (32) |From [P2K_PR_PAY_RUNS], [pay_run_number|PAY_RUN_NUMBER] |
| 320031 | Pay Run Sequence (32) |From [P2K_PR_PAY_HEADERS], [pay_run_sequence|PAY_RUN_SEQUENCE] |
| 320040 | Hired Date (32) | From [P2K_HR_EMPLOYMENTS], [hire_date|HIRE_DATE]|
| 320041 | Term Date (32) | From [P2K_HR_EMPLOYMENTS], [termination_date|TERMINATION_DATE]|
| 320042 | Seniority Date (32) |From [P2K_HR_EMPLOYMENTS], [seniority_date|SENIORITY_DATE] |
| 320043 | First Work Date (32) |From [P2K_HR_EMPLOYMENTS], [first_work_date|FIRST_WORK_DATE] |
| 320044 | Last Work Date (32) | From [P2K_HR_EMPLOYMENTS], [last_work_date|LAST_WORK_DATE]|
| 320100 | Pay Header Stage | From [P2K_PR_PAY_HEADERS], [pay_header_stage|PAY_HEADER_STAGE]|
| 320101 | Pay Number (32) | From [P2K_PR_PAY_HEADERS], [pay_number|PAY_NUMBER]|
| 320102 | Pay Period (32) | From [P2K_PR_PAY_HEADERS], [pay_period|PAY_PERIOD]|
| 320103 | Pay Period Start (32) |From [P2K_PR_PAY_PERIODS], [pay_period_start_date|PAY_PERIOD_START_DATE] of the pay header |
| 320104 | Pay Period End Date (32) |From [P2K_PR_PAY_PERIODS], [pay_period_end_date|PAY_PERIOD_END_DATE] of the pay header |
| 320105 | Pay Issue Date (32) | From [P2K_PR_PAY_HEADERS], [pay_issue_date|PAY_ISSUE_DATE]|
| 320106 | Period Fiscal (32) | From Pay Period Fiscal of Pay Header|
| 320107 | Period Fiscal Start (32) |From Fiscal Start Date of Pay Period Fiscal |
| 320108 | Period Fiscal End (32) | From Fiscal End Date of Pay Period Fiscal|
| 320109 | Issue Fiscal (32) | From Pay Issue Fiscal of Pay Header|
| 320110 | Issue Fiscal Start (32) |From Fiscal Start Date of Pay Issue Fiscal |
| 320111 | Issue Fiscal End (32) | From Fiscal End Date of Pay Issue Fiscal|
| 320200 | G/L Company Code (32) | From [P2K_CM_ENTITIES], [GL Company Code|DGC_ID] |
| 320201 | Entity Code (32) | From [P2K_CM_ENTITIES], [Entity Code|ENTITY_CODE] |
| 320202 | Entity Name (32) | From [P2K_CM_ENTITIES], [Entity Name|ENTITY_NAME]|
| 320203 | Payroll Code (32) |From [P2K_PR_PAYROLLS], [Payroll Code|PAYROLL_CODE] |
| 320204 | Payroll Desc (32) | From [P2K_PR_PAYROLLS], [Payroll description|DESCRIPTION]|
| 320205 | Unit Code (32) | From [P2K_CM_UNITS], [Unit Code|UNIT_CODE]|
| 320206 | Unit Name (32) | From [P2K_CM_UNIT_DETAILS], [Unit Name|UNIT_NAME]|
| 320207 | Group Code (32) | From [P2K_CM_GROUPS],[Group Code|GROUP_CODE] |
| 320208 | Group Desc (32) | From [P2K_CM_GROUP_DETAILS], [Group Description|DESCRIPTION]|
| 320209 | Department Code (32) |From Pay Header assignment [Department Code|DEPARTMENT_CODE] on [P2K_CM_DEPARTMENTS] or Pay Line [Department Code|DEPARTMENT_CODE] if exists |
| 320210 | Department Name (32) | From Pay Header assignment [Department Name|DEPARTMENT_NAME] on [P2K_CM_DEPARTMENT_DETAILS] or Pay Line [Department name|DEPARTMENT_NAME] if exists|
| 320211 | Job Code (32) | From Pay Header assignment [Job Code|JOB_CODE] on [P2K_CM_JOBS] or Pay Line [Job Code|JOB_CODE] if exists|
| 320212 | Job Title (32) | From Pay Header assignment [Job Title|JOB_TITLE] on [P2K_CM_JOB_DETAILS] or Pay Line [Job Title|JOB_TITLE] if exists|
| 320213 | Position Code (32) | From Pay Header assignment [Position Code|POSITION_CODE] on [P2K_CM_POSITIONS] or Pay Line [Position Code|POSITION_CODE] if exists|
| 320214 | Position Title (32) | From Pay Header assignment [Position Title|POSITION_TITLE] on [P2K_CM_POSITION_DETAILS] or Pay Line [Position Title|POSITION_TITLE] if exists|
| 320215 | Assignment Code (32) | From Pay Header [assignment Code|ASSIGNMENT_CODE] on [P2K_HR_ASSIGNMENTS] or Pay Line [assignment Code|ASSIGNMENT_CODE] if exists|
| 320216 | Assignment Title (32) | From Pay Header [assignment Title|ASSIGNMENT_TITLE] on [P2K_HR_ASSIGNMENT_DETAILS] or Pay Line assignment Code Title if exists|
| 320217 | Pay Category Code (32) | From Pay Header [pay_category_code|PAY_CATEGORY_CODE] on [P2K_PR_PAY_CATEGORIES]|
| 320218 | Check Number (32) | From Pay Header [Check Number|CHECK_NUMBER] on [P2K_PR_CHECKS]|
| 320219 | Check Amount (32) | From Pay Header [Check Amount|CHECK_AMOUNT] on [P2K_PR_CHECKS]|
| 320220 | User Name (32) | From Pay Header [User Name|MUS_ID] on [P2K_AM_USERS] |
| 320221 | Work State/Prov (32) |From Pay Header [Work State/Prov|DSP_ID_WORK] on [P2K_PR_PAY_HEADERS] |
| 320222 | Res State/Prov (32) | From Pay Header [Residence State/Prov|DSP_ID_HOME] on [P2K_PR_PAY_HEADERS]|
| 320223 | Work GEO Code (32) | From Pay Header [Work Jurisdiction GEO Code|GEO_CODE] on [P2K_CM_TAX_JURISDICTIONS]|
| 320224 | Res GEO Code (32) | From Pay Header [Residence Jurisdiction GEO Code|DTX_ID_HOME] on [P2K_CM_TAX_JURISDICTIONS]|
| 320225 | Work Jurisdiction (32) |From Pay Header [Work Jurisdiction| DTX_ID_WORK] on [P2K_PR_PAY_HEADERS]|
| 320226 | Res Jurisdiction (32) | From Pay Header [Residence Jurisdiction|DTX_ID_HOME] on [P2K_PR_PAY_HEADERS]|
| 320227 | School District (32) | From Pay Header [School District|DSD_ID] on [P2K_PR_PAY_HEADERS]|
| 320230 | Std Wage (eas) (32) | From Pay Header [Assignment Std Wage|STD_WAGE_RATE]|
| 320231 | Wage Basis (eas) (32) |From Pay Header [Assignment Wage Basis|STD_WAGE_RATE_BASIS] |
| 320232 | Authorization Code (32) |Authorization area is from pay header or pay line's assignment, then position, then department|
| 320300 | PC Code (32) |The [PC Code|PC_CODE] of the current pay line detail or pay amount |
| 320301 | PC Abbrev (32) |The [PC Abbreviation|PC_ABBREVIATION] of the current pay line detail or pay amount |
| 320302 | PC Amount (32) | The [PC Amount|AMOUNT] of the current pay line detail or pay amount|
| 320303 | Element Code (32) |You should specify the '[Element Code|ELEMENT_CODE]' in [IDIF] Constant Value |
| 320304 | Element PC Value (32) | You should specify the '[Element Code|ELEMENT_CODE]' in [IDIF] Constant Value|If the PC Code of the current pay line detail or pay amount is in the [element|PAY ELEMENTS], then the PC Amount is included
| 320305 | Element Desc (32) |You should specify the '[Element Code|ELEMENT_CODE]' in [IDIF] Constant Value |
| 320306 | Element pph Value (32) | You should specify the '[Element Code|ELEMENT_CODE]' in [IDIF] Constant Value|this returns the Element Value of this Pay Header [PPH_ID]
| 320400 | Start Date (ppl) (32) |From Pay Line [Start Date|START_DATE] on [P2K_PR_PAY_LINES] |
| 320401 | Time (ppl) (32) | From Pay Line [Time|TIME_ENTERED] on [P2K_PR_PAY_LINES]|
| 320402 | Time Basis (ppl) (32) |From Pay Line [Time Basis|TIME_BASIS] on [P2K_PR_PAY_LINES] |
| 320403 | Std Wage (ppl) (32) | From Pay Line [Std Wage|STD_WAGE_RATE] on [P2K_PR_PAY_LINES]|
| 320404 | Wage Basis (ppl) (32) |From Pay Line [Wage Basis|STD_WAGE_RATE_BASIS] on [P2K_PR_PAY_LINES] |
| 320405 | Cost Center (ppl) (32) |From Pay Line [Cost Center|COST_CENTER_CODE] on [P2K_CM_COST_CENTERS] |
| 320406 | Cost Center Desc (32) | From Pay Line [Cost Center description|DESCRIPTION] on [P2K_CM_COST_CENTERS]|
| 320407 | Work Order (ppl) (32) | From Pay Line [Work Order|WORK_ORDER] on [P2K_PR_PAY_LINES]|
| 320408 | Reference Info (ppl) (32) |From Pay Line [Reference Info|REFERENCE_INFO] on [P2K_PR_PAY_LINES] |
| 320409 | Tran Pointer (ppl) (32) | From Pay Line [Transaction Pointer|TRANSACTION_POINTER] on [P2K_PR_PAY_LINES]|
| 320410 | Pay Line ID (ppl_id) (32) |From [Pay Line ID|PPL_ID] |
| 320411 | Pay Line Detail (ppld_id) (32) |From [Pay Line Detail ID|PPLD_ID] |
| 320500 | Wage Rate (ppld) (32) | From Pay Line Detail [Wage Rate|WAGE_RATE] on [P2K_PR_PAY_LINE_DETAILS]|
| 320501 | Rate Basis (ppld) (32) | From Pay Line Detail [Rate Basis|RATE_BASIS] on [P2K_PR_PAY_LINE_DETAILS]|
| 320502 | Tran Pointer (ppld) (32) | From Pay Line Detail [Transaction Pointer|TRANSACTION_POINTER] on [P2K_PR_PAY_LINE_DETAILS]|
| 320600 | Total Value (32) | User should specify the Rec# and Field # to be totaled in [IDIF] Constant Value field e.g. if Rec # 50 Field # 70 specifies the hours for each employee and need to be totaled for the trailer record, then for trailer record entry, you should specify 'Total Value' with Constant Value = 5070|This Total Value is available for Header and Trailer records. Multiple Rec# and Field # are allowed in the Constant field e.g. [[611] + [[612] + [[613] + [[623] - [[624]. This means calculate the Totals for Rec# 61 Fld# 1 + Rec# 61 Fld# 2 + Rec# 61 Fld# 3 + Rec# 62 Fld# 3 - Rec# 62 Fld# 4. Any arithmetic operator can be used: +, -, *, /Note: The Accum Option and Total Option must be set for the Rec# Fld# that are specified in this Constant field, i.e.Rec# 61 Fld# 1 etc
| 320601 | Detail Record Count (32) | Contains the Record Count of each set of Rec# 30-69 in the interface file, i.e. one set of [IDIF] Record Type of 'DetailRecord', can be used as employee count e.g. if an employee's one detail record generates three different Record types with Rec# 50, 60, 65, it counts as one because it is for one detail record|This Record Count is available for Header and Trailer records
| 320602 | All Detail Count (32) | Contains the Record Count of all Rec# 30-69 in the interface file e.g. if an employee's one detail record generates 3 different Record types with Rec# 50, 60, 65, it counts as 3 because there are 3 entries generated on interface file|This Record Count is available for Header and Trailer records
| 320603 | User Calc (32) |Indicates this Rec#/Fld# will invoke a UserCalc. You should enter the UserCalc Name in the Constant Value field |
| 320604 | XML Begin Tag (32) |Indicates this Rec#/Fld# is for XML Begin tag |You should enter the XML tag in the XML tag field, if XML tag field is not specified, the Field name is used as XML tag. You should specify XML tag option for this field. If XML tag option is not specified, this XML tag is an optional tag. If you use 320604-XML Begin tag to define the XML tags, you must use 320605-XML End tag to pair with the XML Begin tag. You should use one of the following ways to define XML tags:1) use 320002-XML tag for all Begin and End tags i.e. you specify <Request> and </Request> 2) use 320604-XML Begin tag and 320605-XML End tag . This allows you to use XML tag option to indicate if the XML tag is mandatory or optional. You must not use 320002-XML tag to mix with 320604/320605 definition
| 320605 | XML End Tag (32) |Indicates this Rec#/Fld# is for XML End tag |See 320604- XML Begin tag for detail
| 320606 | UDF (EID) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_IDENTITIES] (EID)|You must define the UDF on [IMUF] screen for [P2K_HR_IDENTITIES] and then enter the value on [IEID] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320607 | UDF (EEM) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_EMPLOYMENTS] (EEM)|You must define the UDF on [IMUF] screen for [P2K_HR_EMPLOYMENTS] and then enter the value on [IEEI] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320608 | UDF (EPS) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_PERSONALS] (EPS)|You must define the UDF on [IMUF] screen for [P2K_HR_PERSONALS] and then enter the value on [IEPI] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320610 | UDF (EASD) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|User must define the UDF on [IMUF] screen for [P2K_HR_ASSIGNMENT_DETAILS] and then enter the value on [IEAS] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-UpdateRecord', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen.
| 320621 | UDF (DED) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_ENTITY_DETAILS] (DED)|User must define the UDF on [IMUF] screen for [P2K_CM_ENTITY_DETAILS] and then enter the value on [IDEN] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320623 | UDF (DDD) (32) |Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_DEPARTMENT_DETAILS] (EASD)|[P2K_CM_DEPARTMENT_DETAILS] and then enter the value on [IDDP] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320624 | UDF (DLN) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_LOCATIONS] (DLN)|User must define the UDF on [IMUF] screen for [P2K_CM_LOCATIONS] and then enter the value on [IDLN] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320626 | UDF (DUD) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_UNIT_DETAILS] (DUD)|User must define the UDF on [IMUF] screen for [P2K_CM_UNIT_DETAILS] and then enter the value on [IDUN] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320628 | UDF (DGD) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_GROUP_DETAILS] (DGD)|User must define the UDF on [IMUF] screen for [P2K_CM_GROUP_DETAILS] and then enter the value on [IDGR] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be Inserted or Updated, you do not need to set up UDF on [IMUF] screen
| 320629 | UDF (PRN) (32) |Indicates this Rec#/Fld# contains a UDF value from [P2K_PR_PAY_RUNS] (PRN) |User must define the UDF on [IMUF] screen for [P2K_PR_PAY_RUNS] and then enter the value on [IPVP] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320630 | UDF (PPH) (32) | Indicates this Rec#/Fld# contains a UDF value from [P2K_PR_PAY_LINES] (PPL)|User must define the UDF on [IMUF] screen for [P2K_PR_PAY_LINES] and then enter the value on [IPPH] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on [IMUF] screen
| 320631 | UDF (PPL) (32) | |
| 320632 | UDF (IDIF) (32)| Indicates this Rec#/Fld# contains a UDF value from P2K_CM_INTERFACE_FORMATS (DIF).|User must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 320650 | Statistic Amt (IEST) (65) | Indicates this Rec#/Fld# contains a Statistics value from [P2K_HR_STATISTICS] (EST)|User must define the Statistics Code on [IDSC] screen for [P2K_CM_STATISTIC_COMPONENTS] and then enter the value on [IEST] screen. On [IDIF] screen, you must enter the [IDSC] Statistics Code in the Constant Value field. On [IDIF] screen, you must enter the [IDSC] Statistics Code in the Constant Value field
| 320651 | Employee Count (32) |Contains Total Count of unique employees in the file across Detail Record Types 'Detail Record' and 'Detail Level 1'. Available for Header and Trailer records| If an employee appears in Detail Record at Rec# 45 and can also be found in 3 additional Detail Record Types with Rec# 50, 60, 65, the employee record will only be counted as 1. If the employee is being bypassed by the BYPASS derivation or the *SKIPREC#* derivation, this record entry will not be used in the Employee Count.|
| 320700 | Journal Entry ID (PJE) (32) | This field holds the [id|PJE_ID] of the current Journal Entry|
| 320701 | Distr Code (PJE) (32) | From [Distribution Code|DISTRIBUTION_CODE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320702 | Journal Source (PJE) (32) | From [Journal Source|JOURNAL_SOURCE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320703 | G/L Post Number (PJE) (32) | From [GL Post Number|GLPOST_NUMBER]on [P2K_PR_JOURNAL_ENTRIES]|
| 320704 | G/L Post Seq (PJE) (32) | From [GL Post Sequence|GLPOST_SEQUENCE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320705 | Trial Journal (PJE) (32) | From [Trial Journal|TRIAL_JOURNAL] on [P2K_PR_JOURNAL_ENTRIES]|
| 320750 | Journal Detail ID (PJD) (32) |This field holds the [id|PJD_ID] of the current Journal Detail |
| 320751 | Pay Line ID (PJD) (32) | This field holds the [PPL_ID] of the current Journal Detail|
| 320752 | Pay Detail ID (PJD) (32) |This field holds the [PPLD_ID] of the current Journal Detail |
| 320753 | Pay Trans ID (PJD) (32) | This field holds the [PTR_ID] of the current Journal Detail|
| 320754 | G/L Fund ID (PJD) (32) | This field holds the [DGF_ID] of the current Journal Detail|
| 320755 | Time Code PTRC_ID (PJD) (32) |This field holds the [PTRC_ID] of the current Journal Detail |
| 320756 | G/L Eff Date (PJD) (32) | From [GL Effective Date|GL_EFFECTIVE_DATE] on [P2K_PR_JOURNAL_DETAILS]|
| 320757 | G/L Amount (PJD) (32) | From [GL Amount|GL_AMOUNT] on [P2K_PR_JOURNAL_DETAILS]|
| 320758 | G/L Amt DR (PJD) (32) | From [GL Amount|GL_AMOUNT] if amount is positive, otherwise 0|
| 320759 | G/L Amt CR (PJD) (32) | From [GL Amount|GL_AMOUNT] if amount is negative,otherwise 0|
| 320760 | G/L Amt-Financial (PJD) (32) | From [GL Amount|GL_AMOUNT] if the DGA [G/L Account Journal Type|JOURNAL_TYPE] for this PJD = '01-Financial', otherwise 0|
| 320761 | G/L Amt-Statistical (PJD) (32) | From [GL Amount|GL_AMOUNT] if the DGA [G/L Account Journal Type|JOURNAL_TYPE] for this PJD = '01-Financial', otherwise 0|
| 320762 | G/L Amt-Time Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '10- Time', otherwise 0|
| 320763 | G/L Amt-Earn Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '11- Earnings', otherwise 0|
| 320764 | G/L Amt-Dedn Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '12- Deduction', otherwise 0|
| 320765 | G/L Amt-Ben Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '13- Benefit', otherwise 0|
| 320780 | Split Percent (PJD) (32) | From [Split Percent|SPLIT_PERCENT] on [P2K_PR_JOURNAL_DETAILS]|
| 320781 | G/L Detail Seq (PJD) (32) |From [GL Detail Sequence|GL_DETAIL_SEQUENCE] on [P2K_PR_JOURNAL_DETAILS] |
| 320782 | Work Order (PJD) (32) | From [Work Order|WORK_ORDER] on [P2K_PR_JOURNAL_DETAILS]|
| 320783 | G/L Pointer (PJD) (32) |From [GL Pointer|GL_POINTER] on [P2K_PR_JOURNAL_DETAILS] |
| 320800 | G/L Account ID (DGA) (32) |This field holds the [id|DGA_ID] of the G/L Account of current journal entry |
| 320801 | G/L Account Code (DGA) (32) | From [GL Account Code|GL_ACCOUNT_CODE] on [P2K_CM_GL_ACCOUNTS] of current G/L Account|
| 320802 | 0802 Account Type (DGA) (32) | From [GL Account Type|ACCOUNT_TYPE] on [P2K_CM_GL_ACCOUNTS] of current G/L Account|
| 320803 | Journal Type (DGA) (32) | From [Journal Type|JOURNAL_TYPE] on [P2K_CM_GL_ACCOUNTS]|
| 320804 | 0804 Account Usage (DGA) (32) |From [Account Usage|ACCOUNT_USAGE] on [P2K_CM_GL_ACCOUNTS] |
| 320805 | 0805 Account Desc (DGA) (32) | From [Account Desc|DESCRIPTION] on [P2K_CM_GL_ACCOUNTS]|
| 320806 | Distr Mask (DGA) (32) | From [Distribution Mask|DISTRIBUTION_MASK] on [P2K_CM_GL_ACCOUNTS]|
| 320807 | Affects Costing (DGA) (32) |From [Affects Costing|AFFECTS_COSTING] on [P2K_CM_GL_ACCOUNTS] |
| 320808 | Pre Payroll (DGA) (32) | From [Pre Payroll|PRE_PAYROLL] on [P2K_CM_GL_ACCOUNTS]|
| 320809 | Post Payroll (DGA) (32) |From [Post Payroll|POST_PAYROLL] on [P2K_CM_GL_ACCOUNTS] |
| 320810 | Retain Detail (DGA) (32) |From [Retain Detail|RETAIN_DETAIL] on [P2K_CM_GL_ACCOUNTS] |
| 320811 | Accrued Required (DGA) (32) |From [Accrued Required|ACCRUAL_REQUIRED] on [P2K_CM_GL_ACCOUNTS] |
| 320812 | I/C Required (DGA) (32) | From [I/C Required|INTERCOMPANY_REQUIRED] on [P2K_CM_GL_ACCOUNTS]|
| 320813 | Posting Date Method (DGA (32) |From [Posting Date Method|POSTING_DATE_METHOD] on [P2K_CM_GL_ACCOUNTS] |
| 320814 | G/L Acct Suffix (DGA) (32) | From [GL Acct Suffix|GL_ACCOUNT_SUFX]on [P2K_CM_GL_ACCOUNTS]|
| 320815 | Acct Charge To (DGA) (32) | From [Acct Charge To|ACCOUNT_CHARGE_TO] on [P2K_CM_GL_ACCOUNTS]|
| 320900 | Pay Component ID (PPC) (32) |This field holds the [id|PPC_ID] of the Pay Component of current journal detail |
| 320901 | PC Code (PPC) (32) | From [PC Code|PC_CODE] on [P2K_PR_PAY_COMPONENTS]|
| 320902 | PC Abbrev (PPC) (32) |From [PC Abbreviation|PC_ABBREVIATION] on [P2K_PR_PAY_COMPONENTS] |
| 320903 | PC Desc (PPC) (32) | From [PC Description|DESCRIPTION] on [P2K_PR_PAY_COMPONENTS]|
| 320904 | PC Action (PPC) (32) |From [PC Action|PC_ACTION] on [P2K_PR_PAY_COMPONENTS] |
| 320905 | Store Results (PPC) (32) |From [Store Results|STORE_RESULTS] on [P2K_PR_PAY_COMPONENTS] |
| 320920 | PC Usage ID (PCU) (32) | This field holds the [id|PCU_ID] of the Pay Component Usage of the pay component of the current journal detail|
| 320921 | PC Usage Code (PCU) (32) | From [PC Usage Code|PC_USAGE_CODE] on [P2K_PR_PC_USAGES]|
| 320922 | PC Usage Type (PCU) (32) | From [PC Usage Type|PC_USAGE_TYPE] on [P2K_PR_PC_USAGES]|
| 320923 | PC Usage Desc (PCU) (32) | From [PC Usage Description|DESCRIPTION] on [P2K_PR_PC_USAGES]|
| 320924 | Unique Item (PCU) (32) | From [Unique Item|UNIQUE_ITEM] on [P2K_PR_PC_USAGES]|
| 320925 | Mandatory (PCU) (32) | From [Mandatory|MANDATORY] on [P2K_PR_PC_USAGES]|
| 320926 | Legislation (PCU) (32) |From [Legislation|LEGISLATION] on [P2K_PR_PC_USAGES] |
| 320927 | PC G/L Type (PCU) (32) |From [PC GL Type|PC_GL_TYPE] on [P2K_PR_PC_USAGES] |
| 321000 | Pays Per Year (PPP) (32) | |
| 327010 | Read IMCT Custom Key (32) |Read IMCT Custom Table Key of the specified UPPHF list of Custom Table Names
| 327011 | Read IMCT Custom Subkey (32) |Read IMCT Custom Table Subkey of the specified UPPHF list of Custom Table Names
| 327012 | Read IMCT Custom Data (32) | Read IMCT Custom Table Data of the specified UPPHF list of Custom Table Names
At line 781 removed 26 lines
Entity: - mandatory, the user must enter one ‘Entity Code’ to be processed
Payroll: - mandatory, the user must enter one ‘Payroll Code’ to be processed
- Pay Headers must belong to this Payroll Code in order to be processed
Department: - optional, multiple ‘Department Code’ are allowed to be entered
Org Level Type: - optional, one or multiple ‘Org Level Type’ are allowed to be entered
- user may enter ‘Org Type 02’, ‘Org Type 03’ etc to process applicable level types or
user may enter ‘Org Type 02’ to process only this Level
Org Level: - optional, one or multiple ‘Org Level’ are allowed to be entered within the specified Org Level Types
- if multiple Org Level Types are entered, then user may process across multiple levels
Authorization: - optional, one or multiple ‘Authorization area’ are allowed to be entered
- the authorization area is retrieved from Pay Header or Pay line’s assignment if authorization exists at assignment level, otherwise retrieve from position of the assignment if it exists, otherwise retrieve from department of the assignment
Unit: - optional, multiple ‘Unit Code’ are allowed to be entered
Group: - optional, multiple ‘Group Code’ are allowed to be entered
Cost Center: - optional, multiple ‘Cost Center Code’ are allowed to be entered
- the cost centers are retrieved from Pay Lines and therefore cost centers are not applicable at Pay Header level
Pay Run Number - optional, user may select list of Pay Run numbers for the Payroll code specified
Person Code: - the user may enter list of ‘Person Code’
From Pay Period: - optional, the user may select a From Pay Period for the Payroll code specified
To Pay Period: - optional, the user may select a To Pay Period for the Payroll code specified
- e.g. From Pay Period: 200402
To Pay Period: 200404
From Pay Issue Date: - optional, the user may select a From Pay Issue Date for the Pay Headers
To Pay Issue Date: - optional, the user may select a To Pay Issue Date for the Pay Headers
- if the From-To Pay Issue Dates are entered, each Pay Header’s Pay Issue Date must be within this date range in order to be processed
As Of - this date is used to retrieve Pay Runs that are with Pay Period end date or Pay Issue date that are on or prior to this As of date
Interface Format Code - select Interface Format Code that is with Interface Type = ’32-Pay History Interface’
At line 808 changed 5 lines
Interface Level - mandatory, specify the level for the Interface file to be produced
- lexicon X_INTERFACE_UPPHF values are:
01 – Pay Headers
02 – Pay Headers + Pay Lines
10 – Journal Entries
!!Available EEM/EAS Interface (35) Variables
Variables that are available in the EEM/EAS interfaces can be referenced in a Pay History interface. They are not available via the variable field and can only be used via the Derivation Expression field.
At line 814 changed 18 lines
Directory Name - enter valid directory name for interface file
File name - enter file name for interface file
- if the word ‘mex’ is specified in the file name, then it will be replaced with the current execution id of UPPHF run
- for fixed format file, you may specify a file with extension .txt
- for comma delimited format file, you may specify a file with extension .csv
- for xml file, you may specify a file with extension .xml
Write/Append to File - this specifies if the Interface File is to be overwritten or appended
- lexicon: X_WRITE_APPEND
A – Append to File
W – Write to File
Exception Level - if Exception Level = ‘0’, only exception messages will be printed
- if Exception Level = ‘1’, one line will be printed per Pay Header with performance time
- if Exception Level = ‘2’, one line will be printed per Pay Header with performance time and one line per Detail Level 1 record
- if Exception Level = ‘8’ or ‘9’, full utility trace, available only if user selects by Person code, otherwise UPPHF will internally reset to Exception level ‘1’ due to volume of trace messages
User Comment - enter the user comment to be displayed on first page of the report
Trial Run - optional toggle to indicate if the UDFs are to be updated for the UPPHF run
- the value of ‘Y’ or ‘N’ is always returned in this parameter field
- to run in non-Trial mode (Update mode), the user should define IDIF Record Type ’92-Update Record’ to update UDFs
To reference these values, the saved value (35XXXX) must be encased in __parenthesis __ within the derivation expression field.\\
\\
At line 647 added 558 lines
%%zebra-table
||Saved\\Value||Displayed Value||Source of Data||Comments
| 350001 | XML Begin Tag | |Indicates this Rec#/Fld# is for XML Begin tag.\\ \\You should enter the XML tag in the XML tag field. If XML tag is not specified, the field name is used as XML Tag.\\ \\You should specify XML tag option.\\ \\If XML tag option is not specified, this XML tag is an optional tag.
| 350002 | XML End Tag | |Indicates this Rec#/Fld# is for XML End tag.\\ \\Same logic as XML Begin tag.\\ \\You should match XML End tag to XML Begin tag on [IDIF] definition
| 350003 | Constant Value | | Indicates this Rec#/Fld# contains a constant.\\ \\You should enter the constant in Constant Value field.
| 350004 | System Date/Time | |The system current Date and Time stamp with following Select: SELECT to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')\\ \\You can use derivation expression SUBSTR to retrieve Date only or Time only
| 350005 | As Of Date | From the [UEEF] As Of Date parameter|
| 350006 | Execution ID | From the [UEEF] Execution ID of the run|
| 350007 | User Calc | |Indicates this Rec#/Fld# will invoke a UserCalc.\\ \\You should enter the UserCalc name in the Constant Value field, e.g. BE USERCALC\\ \\Please read [IDIF User Calc|UEEF#section-UEEF-Step3DefiningUserCalcs] section.
| 350008 | Trial Run |From the P_TRIAL (Trial Run) parameter|The value of <<Y>> or <<N>> is always returned in P_TRIAL\\ \\If NULL is entered, P_TRIAL is set to <<N>>
| 350100 | Entity den_id (DEN)) | [P2K_CM_ENTITIES] (DEN) is retrieved from employee's employment. |This field returns the [DEN_ID], you may use this id in derivation expression to return other value that is related to [DEN_ID]\\ \\e.g. To return the UDF 'COMPANY LICENCE' value from [IDEN], use derivation expression:\\ \\p2k_smgetudf ('P2K_CM_ ENTITIES', 'COMPANY LICENCE',~)
| 350101 | Entity Code (DEN) | From [P2K_CM_ENTITIES] (DEN) [Entity Code|ENTITY_CODE]|
| 350102 | Standing (DEN) | From [P2K_CM_ENTITIES] (DEN) [Standing|STANDING]|
| 350103 | G/L Company (DEN)|From [P2K_CM_ENTITIES] (DEN) GL Company id to retrieve [GL Company code|GL_COMPANY_CODE] |
| 350110 | Effective (DED) | From [P2K_CM_ENTITY_DETAILS] (DED) effective as of the [UEEF] As of Date parameter|
| 350111 | Expiry (DED) | From [P2K_CM_ENTITY_DETAILS] (DED)|
| 350112 | Entity Name (DED) |From [P2K_CM_ENTITY_DETAILS] (DED) |
| 350113 | Legislation (DED) |From [P2K_CM_ENTITY_DETAILS] (DED) |
| 350114 | Language Code (DED) | From [P2K_CM_ENTITY_DETAILS] (DED)|
| 350115 | Currency (DED) |From [P2K_CM_ENTITY_DETAILS] (DED) |
| 350116 | DUNS Number (DED) | From [P2K_CM_ENTITY_DETAILS] (DED)|
| 350117 | WEB Address (DED) | From [P2K_CM_ENTITY_DETAILS] (DED)|
| 350201 | Location Code (DLN) | [P2K_CM_LOCATIONS] (DLN) is retrieved from the [location code|LOCATION_CODE] field found on IDEN (DED.DLN_ID).|If the [UEEF] parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
| 350202 | Location Desc (DLN) |From [P2K_CM_LOCATIONS] (DLN) |
| 350203 | Font HTML (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350204 | Language Code (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350205 | Address 1 (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350206 | Address 2 (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350207 | Addr Ln2 + Locality (DLN) |From [P2K_CM_LOCATIONS] (DLN) |Location Address Line 2 and Locality (city) are concatenated
| 350212 | Locality (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350213 | State Code (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350214 | Country Code (DLN) |From [P2K_CM_LOCATIONS] (DLN) |
| 350215 | Zip Postal (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350216 | State+Cntry+Zip (DLN) |From [P2K_CM_LOCATIONS] (DLN) |Location State/Prov, Country and Postal Code are concatenated
| 350220 | Mail Address 1 (DLN) | From [P2K_CM_LOCATIONS] (DLN)|If Mailing address does not exist, the primary address will be used
| 350221 | Mail Address 2 (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350222 | Mail Ln2 + Locality (DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address Line 2 and Locality (city) are concatenated
| 350223 | Mail City (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350224 | Mail State Province (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350225 | Mail Country Code (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350226 | Mail Zip Postal (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350227 | Mail State+Cntry+Postal(DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address State/Prov, Country and Postal Code are concatenated
| 350237 | Phone Number (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350238 | Phone Number Ext (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350239 | Alt Phone Number (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350240 | Alt Phone Number Ext (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350241 | Fax Number (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350242 | Email Address (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350243 | Bilingual Region (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350244 | Bilingual Location (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350245 | CMA Code (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350300 | Department ddp_id (DDP) | [P2K_CM_DEPARTMENTS] (DDP) is retrieved from employee's prime assignment|This field returns the [DDP_ID], user may use this id in derivation expression to return other value that is related to [DDP_ID]
| 350301 | Department Code (DDP) | From [P2K_CM_DEPARTMENTS] (DDP)|
| 350302 | Standing (DDP) | From [P2K_CM_DEPARTMENTS] (DDP)|
| 350303 | Generic Code (DDP) | From [P2K_CM_DEPARTMENTS] (DDP)|
| 350310 | Effective (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD) effective as of the [UEEF] As of Date parameter|
| 350311 | Expiry (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350312 | Department Name (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350313 | Distribution Mask (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350314 | Burden Percent (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350315 | Phone Number (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350316 | Phone Number Ext (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350317 | Fax Number (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350318 | Email Address (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350319 | EEOC Function (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350320 | Batch Code (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350321 | Office Code (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350322 | Burden Method (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350400 | Unit dun_id (DUN) |[P2K_CM_UNITS] (DUN) is retrieved from employee's prime assignment|This field returns the [DUN_ID], you may use this id in derivation expression to return other value that is related to [DUN_ID]
| 350401 | Unit Code (DUN) | From [P2K_CM_UNITS] (DUN)|
| 350402 | Standing (DUN) | From [P2K_CM_UNITS] (DUN)|
| 350410 | Effective (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD) effective as of the [UEEF] As of Date parameter|
| 350411 | Expiry (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350412 | Unit Status (DUD) |From [P2K_CM_UNIT_DETAILS] (DUD) |
| 350413 | Unit Description (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350414 | Agreement Start Date (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350415 | Agreement End Date (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350416 | Unit Name (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350417 | Unit Local (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350418 | Unit Sub Local (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350419 | Unit Text (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350500 | Group dgr_id (DGR) | [P2K_CM_GROUPS] (DGR) is retrieved from the employee's prime assignment [DGR_ID]| This field returns the [DGR_ID], you may use this id in derivation expression to return other value that is related to [DGR_ID]
| 350501 | Group Code (DGR) | From [P2K_CM_GROUPS] (DGR)|
| 350502 | Standing (DGR) | From [P2K_CM_GROUPS] (DGR)|
| 350510 | Effective (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD) effective as of the [UEEF] As of Date parameter|
| 350511 | Expiry (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350512 | Group Description (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350513 | Group Type (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350514 | Pay Type (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350515 | Contract Type (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350516 | Employment Type (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350517 | Std Hours Per Day (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350518 | Std Hours Per Week (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350519 | Std Hours Per Pay (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350520 | Weeks Per Year (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350521 | Months Per Year (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350522 | Hourly Rounding (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350523 | Daily Rounding (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350524 | Use FTE Wages (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350525 | Accrual Method (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350526 | CDN EI Reduced Rate (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350527 | Pay By Check (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350528 | FLSA Factor (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350529 | FLSA Hours (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350530 | W2 Employment Type (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350601 | Payroll Code (PPA) | [P2K_PR_PAYROLLS] (PPA) is retrieved from the employee's prime assignment group details|This field returns the [Payroll code|PAYROLL_CODE] from PPA.
| 350602 | Legislation (PPA) | From [P2K_PR_PAYROLLS] (PPA)|
| 350603 | Description (PPA) |From [P2K_PR_PAYROLLS] (PPA) |
| 350701 | Pay Calendar Code (PCL) | [P2K_PR_PAY_CALENDARS] (PCL) is retrieved from the employee's prime assignment group details [Payroll code|PAYROLL_CODE]|This field returns the [Pay Calendar code|PAY_CALENDAR_CODE] from PCL.
| 350702 | Pay Frequency (PCL) |From [P2K_PR_PAY_CALENDARS] (PCL) |
| 350703 | Weeks Per Pay (PCL) | From [P2K_PR_PAY_CALENDARS] (PCL)|
| 350704 | Pay Calendar Desc (PCL) | From [P2K_PR_PAY_CALENDARS] (PCL)|
| 350800 | Govt Regist Number (DGV) |[P2K_CM_GOVT_REGISTRATIONS] (DGV) is retrieved from the employee's prime assignment group details Federal Registration. |This field returns the [Govt Regist Number|GOVT_REGIST_NUMBER] from DGV.
| 350801 | Govt Regist dgv_id (35) |From [P2K_CM_GOVT_REGISTRATIONS] (DGV) |
| 350802 | Govt Regist Type (DGV) | From [P2K_CM_GOVT_REGISTRATIONS] (DGV)|
| 350803 | Govt Regist Desc (DGV) | From [P2K_CM_GOVT_REGISTRATIONS] (DGV)|
| 353100 | Person Code (EID) | [P2K_HR_IDENTITIES] (EID) is retrieved for the employee.|This field returns the [Person code|PERSON_CODE].
| 353101 | Person eid_id (EID) | From [P2K_HR_IDENTITIES] (EID)|Derivation expression to return other value that is related to [EID_ID] e.g. to return the UDF 'LICENCE' value from [IEID], use derivation expression:p2k_smgetudf ('P2K_HR_IDENTITIES','LICENCE',~).
| 353102 | S.S.N. (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353103 | First Name (EID) |From [P2K_HR_IDENTITIES] (EID) |
| 353104 | Middle Name (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353105 | Last Name (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353106 | Last, First, Middle (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: Last name + ',' + First name + space + Middle name\\e.g. Smith, Mary Beverley
| 353107 | Last, First, Initial (EID) |From [P2K_HR_IDENTITIES] (EID)| The employee's name is returned as follows: Last name + ',' + First name + space + Middle Initial\\e.g. Smith, Mary B
| 353108 | First, Middle, Last (EID) | From [P2K_HR_IDENTITIES] (EID)|The employee's name is returned as follows: First name + space + Middle name + space + Last name\\e.g. Mary Beverley Smith
| 353109 | First, Initial, Last (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: First name + space + Middle Initial + space + Last name\\e.g. Mary B Smith
| 353126 | Birth Date (EID) |From [P2K_HR_IDENTITIES] (EID) |
| 353127 | Gender (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353128 | Language Code (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353129 | Ethnic (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353130 | Salutation (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353131 | Rank (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353132 | Birth Place (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353133 | Challenged (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353134 | Veteran Status (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353135 | Photo Location (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353136 | Drivers License (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353137 | Alt Language Code (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353138 | Govt Code Origin (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353139 | User Code (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353200 | Personal eps_id (EPS) |[P2K_HR_PERSONALS] (EPS) is retrieved for the employee, effective as of the [UEEF] As of Date parameter. |This field returns the [EPS_ID], you may use this id in derivation expression to return other value that is related to [EPS_ID].
| 353201 | Effective (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353202 | Expiry (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353203 | Change Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353204 | Address 1 (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353205 | Address 2 (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353206 | Addr Ln2 + Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Address Line 2 and Locality (city) are concatenated.
| 353207 | Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353210 | State Prov Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353211 | Country Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353212 | Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353213 | State+Cntry+Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Address State/Prov, Country and Postal Code are concatenated.
| 353214 | School District Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353215 | Tax Jurisdiction (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353220 | Mail Address 1 (EPS) | From [P2K_HR_PERSONALS] (EPS)|If Mailing address does not exist, the Primary address will be used.
| 353221 | Mail Address 2 (EPS) | From [P2K_HR_PERSONALS] (EPS) |
| 353222 | Mail Adr 2 + Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Mailing Address Line 2 and Locality (city) are concatenated
| 353223 | Mail Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353224 | Mail State Prov (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353225 | Mail Country Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353226 | Mail Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353227 | Mail State+Cntry+Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Mailing Address State/Prov, Country and Postal Code are concatenated.
| 353238 | Phone Unlisted (EPS) |From [P2K_HR_PERSONALS] (EPS) |
| 353239 | Phone Number (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353240 | Alt Phone Number (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353241 | Cellular Number (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353242 | Fax Number (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353243 | Email Address (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353244 | Marital Status (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353245 | Married Date (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353246 | Number Dependents (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353247 | Years Education (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353248 | Transportation (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353249 | Bonded Status (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353250 | Citizen Status (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353251 | Citizenship Country (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353252 | Foreign Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353300 | Employment eem_id (EEM) | [P2K_HR_EMPLOYMENTS] (EEM) is retrieved for the employee|This field returns the [EEM_ID], you may use this id in derivation expression to return other value that is related to [EEM_ID].
| 353301 | Employment Type (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353302 | Hire Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353303 | Hire Sequence (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353304 | Original Hire Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353305 | Seniority Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353306 | First Work Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353307 | Last Work Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353308 | Termination Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353309 | Termination Code (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353310 | Roe Status (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353311 | Roe Issued Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353312 | Roe Letter (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353313 | Roe Comments (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353314 | Rehire Status (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353315 | Expected Return Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353316 | Income Guarantee (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353380 | Term Description (DTR) | [P2K_CM_TERMINATION_REASONS] (DTR) is retrieved from the employee's Employment|This field returns the [Termination description|DESCRIPTION].
| 353381 | Govt Term Code (DTR) | From [P2K_CM_TERMINATION_REASONS] (DTR)|
| 353382 | ROE Letter (DTR) | From [P2K_CM_TERMINATION_REASONS] (DTR)|
| 353383 | Employment Status (DTR) | From [P2K_CM_TERMINATION_REASONS] (DTR)|
| 353384 | Term Code (DTR) | From [P2K_CM_TERMINATION_REASONS] (DTR)|
| 353390 | Pay Frequency (ROE) | From [UPROEF] program internal Pay Frequency| For [UPROEF] only, please read Web ROE doc for detail
| 353391 | First day worked (ROE) |From [UPROEF] program internal First day worked|
| 353392 | Last day paid (ROE) | From [UPROEF] program internal Last day paid|
| 353393 | Final period end (ROE) |From [UPROEF] program internal Final period end |
| 353394 | Reason issue (ROE) | From [IEEI] UDF '[ROE REASON CODE|ROE REASON CODE (UDF)]' if specified, otherwise from [IEEI] [TERMINATION_CODE] [ROE_LETTER]| When employee is terminated, the [IEEI] EMPLOYMENT specifies a Termination Reason. The '[Termination Reason|TERMINATION_CODE]' is defined on [IDTR] screen with an [ROE_LETTER]. Used by [UPROEF]
| 353395 | ROE process meth (ROE) |From [UPROEF] program internal Process method |
| 353396 | ROE Comment line 1 (ROE) |From [UPROEF] program internal Comment line 1 |
| 353397 | ROE Comment line 2 (ROE) | From [UPROEF] program internal Comment line 2|
| 353398 | ROE Comment line 3 (ROE) | From [UPROEF] program internal Comment line 3|
| 353399 | ROE Comment line 4 (ROE) | From [UPROEF] program internal Comment line 4|
| 353400 | Assignment eas_id (EAS) | [P2K_HR_ASSIGNMENTS] (EAS) is retrieved for the employee's Primary assignment| This field returns the [EAS_ID], you may use this id in derivation expression to return other value that is related to [EAS_ID]
| 353401 | Assignment Code (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353402 | Assignment Type (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353403 | Assignment Status (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353404 | Assignment Start Date (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353405 | Assignment End Date (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353406 | Prime Assignment (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353407 | Description (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353408 | Next Review Date (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353409 | Ts Seniority Date (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353500 | Assignment easd_id (EASD) | [P2K_HR_ASSIGNMENT_DETAILS] (EASD) is retrieved for the employee's Primary assignment effective as of the As of Date parameter|This field returns the easd.id, you may use this id in derivation expression to return other value that is related to [EASD_ID].
| 353501 | Effective (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353502 | Expiry (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353503 | Change Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353504 | Employment Status Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353505 | Position Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353506 | Job Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353507 | Department Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353508 | Unit Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353509 | Group Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353510 | Location Work In (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353511 | Location Paydest (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353512 | Authorization Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353513 | Tax Jurisdiction (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353514 | Work Calendar (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353515 | Work Rule (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353516 | Supervised By (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353517 | Replaced By (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353518 | Job Profile (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353519 | Range Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353520 | Scale Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353521 | Step Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353522 | Fte (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353523 | Assignment Title (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353524 | Hours Per Day (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353525 | Hours Per Week (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353526 | Hours Per Pay (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353527 | Wage Rate (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353528 | Rate Basis (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353529 | Use Fte Wages (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353530 | Out Of Range (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353531 | Scale Overridden (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353532 | Periods Elected (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353533 | Pay Starting Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353534 | Contract Days (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353535 | Contract Limit (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353536 | Job Seniority Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353537 | Service Rating (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353538 | Responsibility Level (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353539 | Work Type (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353540 | WC Class (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353541 | Phone Number (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353542 | Phone Extension (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353543 | Email Address (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353544 | Leave Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353545 | Leave Reason (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353546 | Leave Return Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353547 | Trigger Retro (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353548 | Provide Public Sve (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353549 | Provide Internal Sve (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353550 | Supervisory (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353551 | Job Class Lex Value | If the Entity Detail (DED) legislation is for US, [P2K_PR_US_PAY_RULES] (PPRU) is retrieved for the employee's Employment effective as of the As of Date parameter|
| 353602 | Effective (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353603 | Expiry (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353604 | Change Code (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353605 | Ufed Filing Status (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353606 | Ufed Num Exemptions (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353607 | Ufed Ann Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353608 | Ufed Add Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353609 | Ufed Add Tax Per Prd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353610 | Ufed Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353611 | Ufed Tax Percent (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353612 | Ufed Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353613 | Ufed Suppl Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353614 | Ufed Fica Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353615 | Ufed Medicare Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353616 | Ufed Futa Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353617 | Ufed Eic Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353618 | Ust Reciprocation (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353619 | Ust Filing Status (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353620 | Ust Num Exemption 1 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353621 | Ust Num Exemption 2 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353622 | Ust Ann Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353623 | Ust Add Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353624 | Ust Add Tax Per Prd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353625 | Ust Add Tax Res (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353626 | Ust Add Tax Work (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353627 | Ust Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353628 | Ust Tax Percent (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353629 | Ust Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353630 | Ust Suppl Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353631 | Ust Alt Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353632 | Ust Sui Ee Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353633 | Ust Sui Er Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353634 | Ust Sdi Ee Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353635 | Ust Sdi Er Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353636 | Ust WC Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353637 | Uloc Reciprocation (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353638 | Uloc Filing Status (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353639 | Uloc Num Exemptions (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353640 | Uloc Ann Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353641 | Uloc Exempt Percent (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353642 | Uloc Add Tax Per Prd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353643 | Uloc Add Tax Work (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353644 | Uloc Add Tax Res (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353645 | Uloc Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353646 | Uloc Tax Percent 1 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353647 | Uloc Tax Percent 2 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353648 | Uloc County Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353649 | Uloc City Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353650 | Uloc School Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353651 | Uloc School Tax Amt (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353652 | Uloc School Tax % (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353653 | Uloc Head Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353654 | Uloc Head Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353655 | Ust Eic Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353701 | Effective (PPRC) | if the Entity Detail (DED) legislation is for Canada, [P2K_PR_CDN_PAY_RULES] (PPRC) is retrieved for the employee's Employment effective as of the As of Date parameter|
| 353702 | Expiry (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353703 | Change Code (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353704 | Cfed Td1 Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353705 | Cfed Ann Tax Credit (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353706 | Cfed Ann Tax Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353707 | Cfed Ann Area Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353708 | Cfed Tax Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353709 | Cfed Tax Percent (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353710 | Cfed Add Tax Per Prd (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353711 | Cfed Filing Status (PPRC) | From[ P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353712 | Cfed Tax Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353713 | Cfed Cpp Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353714 | Cfed Ei Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353715 | Cfed Labour Fund (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353716 | Cprv Claim Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353717 | Cprv Num Dependents (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353718 | Cprv Ann Tax Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353719 | Cprv Tax Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353720 | Cprv Tax Percent (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353721 | Cprv Add Tax Per Prd (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353722 | Cprv Filing Status (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353723 | Cprv Tax Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353724 | Cprv Qpp Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353725 | Cprv Health Tax Mthd (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353726 | Cprv WC Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353727 | Fed Tax Claim Type (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353728 | Fed Tax Claim Code (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353729 | Prov Tax Claim Type (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353730 | Prov Tax Claim Code (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353731 | Cprv Ann Tax Credit (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353732 | Cprv Ann Area Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353801 | Contacts ect_id (ECT) |From [P2K_HR_CONTACTS] (ECT) |If the Interface Level parameter = '02 - EEM + EASD + Contacts', [P2K_HR_CONTACTS] (ECT) is retrieved for the employee's Identity (EID). If the Interface Level parameter = '04 - BE Plans + Contacts', [P2K_HR_CONTACTS] (ECT) is retrieved for the employee's Benefit Recipients (BBR) of the Benefit Enrollment (BEN) of the Employments (EEM)
| 353802 | First_name (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353803 | Middle_name (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353804 | Last_name (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353805 | Last, First, Middle (ECT) | From [P2K_HR_CONTACTS] (ECT)|The contact's name is returned as follows: Last name + ',' + First name + space + Middle name\\e.g. Smith, Mary Beverley
| 353806 | Last, First, Initial (ECT) |From [P2K_HR_CONTACTS] (ECT) |The contact's name is returned as follows: Last name + ',' + First name + space + Middle Initial\\e.g. Smith, Mary B
| 353807 | First, Middle, Last (ECT) | From [P2K_HR_CONTACTS] (ECT)|The contact's name is returned as follows: First name + space + Middle name + space + Last name\\e.g. Mary Beverley Smith
| 353808 | Gender (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353809 | Relation (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353810 | S.S.N. (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353811 | Birth_date (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353812 | Language_code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353813 | Salutation (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353814 | Rank (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353815 | Employer (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353816 | Contact_title (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353817 | Address_line_1 (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353818 | Address_line_2 (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353819 | Addr Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact's Address Line 2 and Locality (city) are concatenated.
| 353820 | City (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353821 | State Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353822 | Country Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353823 | Zip Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353824 | State+Cntry+Zip (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact's Address State/Prov, Country and Postal Code are concatenated.
| 353825 | Mail_address_line_1 (ECT) |From [P2K_HR_CONTACTS] (ECT) |If Mailing address does not exist, the primary address will be used.
| 353826 | Mail_address_line_2 (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353827 | Mail Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact's Mailing Address Line 2 and Locality (city) are concatenated
| 353828 | Mail City (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353829 | Mail State (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353830 | Mail Country Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353831 | Mail Zip Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353832 | Mail State+Cntry+Zip (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact's Mailing Address State/Prov, Country and Postal Code are concatenated
| 353833 | Phone_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353834 | Phone_extension (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353835 | Alt_phone_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353836 | Alt_phone_extn (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353837 | Cellular_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353838 | Fax_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353839 | Email_address (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353840 | Security_level (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353841 | Private_item (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353842 | Web_address (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353843 | Govt_code_origin (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353844 | Contacts eid_id (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353845 | Contacts mus_id (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 355001 | Enrollment id (BEN) |[P2K_BE_ENROLLMENTS] (BEN) |If the Interface Level parameter = '03 - BE Plans' or '04 - BE Plans + Contacts', [P2K_BE_ENROLLMENTS] (BEN)is retrieved for the user specified Benefit Plan codes and Benefit Plan types of the report's parameter. Tthis field returns the [BEN_ID], you may use this id in derivation expression to return other value that is related to [BEN_ID].
| 355002 | Enroll Detail id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for BEN effective as of the As of Date parameter|This field returns the [BEND_ID], you may use this id in derivation expression to return other value that is related to [BEND_ID].
| 355003 | Effective (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355004 | Expiry (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355005 | Unofficial (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355006 | Enrollment_status (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355007 | Participation_rule (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355008 | Coverage_step_code (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355009 | Description (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355010 | Elig_start_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355011 | Elig_end_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355012 | Prem_start_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355013 | Prem_end_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355014 | Plan_reg_number (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355015 | Evidence_of_ins (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355016 | Percentage (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355020 | Freq pfq_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355021 | Change reason dcr_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355022 | Covg bcg_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355023 | Orig bend_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355101 | Plan Type id (BPT) | From [P2K_BE_ENROLLMENTS] (BEN), it links to the [P2K_BE_PLAN_DEFINITIONS] (BPN) which links to [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)| This field returns the [BPT_ID], you may use this id in derivation expression to return other value that is related to [BPT_ID].
| 355102 | Plan_type_code (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)|
| 355103 | Description (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)|
| 355104 | Calc_sequence (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)|
| 355201 | Plan Defn id (BPN) | From [P2K_BE_ENROLLMENTS] (BEN), it links to the [P2K_BE_PLAN_DEFINITIONS] (BPN)|This field returns the [BPN_ID], you may use this id in derivation expression to return other value that is related to [BPN_ID].
| 355202 | Plan_code (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355203 | Description (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355204 | Plan_access_code (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355205 | Established_date (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355206 | Participation_rule (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355207 | Policy_number (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355208 | Calc_sequence (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355209 | Plan_remit_seq (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355210 | Track_decline (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355211 | Last_remit_date (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355212 | Remit_by_state (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355213 | Remit_by_un_grp (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355214 | Remit_date_rule (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355215 | Remit_asof_day (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355216 | Print_zero_rule (BPN) | From [P2K_BE_PLAN_DEFINITIONS](BPN)|
| 355217 | Print_all_waivers (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355218 | Not_scheduled (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355219 | Plan_end_date (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355220 | Approval_required (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355221 | Plan den_id (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355222 | Plan dcl_id (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355223 | Plan brm_id (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355301 | Coverage id (BCG) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for this employee for this benefit plan, it links to the [P2K_BE_COVERAGES] (BCG) to indicate the coverage the employee has elected for the BE plan|This field returns the [BCG_ID], you may use this id in derivation expression to return other value that is related to [BCG_ID].
| 355302 | Coverage_code (BCG) |From [P2K_BE_COVERAGES] (BCG) |
| 355303 | Covg_remit_seq (BCG) |From [P2K_BE_COVERAGES] (BCG) |
| 355304 | Policy_number (BCG) | From [P2K_BE_COVERAGES] (BCG)|
| 355305 | Contact_role (BCG) | From [P2K_BE_COVERAGES] (BCG)|
| 355306 | Covg muc_id (BCG) | From [P2K_BE_COVERAGES] (BCG)|
| 355401 | Covg Detail id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD) effective as of the As of Date parameter|
| 355402 | Effective (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355403 | Expiry (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355404 | Remit_basis (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355405 | Rate_basis (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355406 | Description (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355407 | Covg Detail pfq_id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355408 | Covg Detail dcr_id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355501 | Covg Rate id (BCGR) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for this employee for this benefit plan, it specifies the [COVERAGE_STEP_CODE] to indicate the coverage step the employee has elected for the BE plan. [P2K_BE_COVERAGE_RATES] (BCGR) is retrieved for the BEND Benefit Coverage Detail and [COVERAGE_STEP_CODE].|This field returns the [BCGR_ID], you may use this id in derivation expression to return other value that is related to [BCGR_ID].
| 355502 | Covg_step_code (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355503 | Description (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355504 | Up_to_limit (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355505 | Next_step_code (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355506 | Flex_amount (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355507 | Premium1_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355508 | Premium2_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355509 | EE_deduct_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355510 | ER_contrib_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355511 | Taxben_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355512 | User1_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355513 | User2_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355514 | User3_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355601 | Ben Recip id (BBR) |From [P2K_BE_BENEFIT_RECIPIENTS] (BBR) |If the Interface Level parameter = '04 - BE Plans + Contacts', the function (ie [UEEF]) will retrieve the Benefit Recipients [P2K_BE_BENEFIT_RECIPIENTS] (BBR) for the Benefit Enrollment (BEN) in order to retrieve the Benefit Contacts (ECT) information that links to Benefit Recipients. This field returns the [BBR_ID], you may use this id in derivation expression to return other value that is related to [BBR_ID].
| 355602 | Start_date (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
| 355603 | End_date (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
| 355604 | Benefit_percent (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
| 355605 | Bond_participation (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
| 356100 | PPH_ID (PPH) | |
| 356101 | Pay Number (PPH) | |
| 356102 | Tax Weeks (PPH) | |
| 356103 | Pay Issue Date (PPH) | |
| 356104 | PPP Start Date (PPH) | |
| 356105 | First Pay in Issue Month | |
| 356106 | Last Pay in Issue Month | |
| 356200 | Pay Line ID (PPL) | |
| 356201 | Pay Line Status (PPL) | |
| 356202 | PL State Date (PPL) | |
| 356203 | PL End Date (PPL) | |
| 356204 | Time Entered (PPL) | |
| 356205 | Time Basis (PPL) (35) | |
| 356206 | PL Source (PPL) | |
| 356207 | Retro Pay (PPL) | |
| 356208 | First Date of PPL Date | |
| 356209 | Last Date of PPL Date | |
| 356210 | Affected Month (PPL) | |
| 356220 | Nbr Pays in PPL Month | |
| 356300 | PPLD_ID | |
| 356301 | PL Detail status (PPLD) | |
| 356302 | Wage Rate (PPLD) | |
| 356303 | Wage Rate O/R (PPLD) | |
| 356304 | Rate Basis (PPLD) | |
| 356305 | Rate Basis O/R (PPLD) | |
| 356306 | Amount (PPLD) | |
| 356307 | Amount O/R (PPLD) | |
| 356308 | Amount Processed (PPLD) | |
| 356309 | Retro Amount (PPLD) | |
| 356310 | PPC_ID (PPLD) | |
| 356312 | PPC in Element-1 (Internal) | |
| 356313 | PPC in Element-2 (Internal) | |
| 358001 | Internal Table Desc1 | |A temporary internal PL/SQL table is defined for the Generic Interface program. This PL/SQL table holds information for up to five columns. Each column has a description and an amount and each amount can be totaled. Depending on each business requirement, the program will load information into this PL/SQL table for internal purpose. (e.g. [UPROEF] uses this table to hold up to 52 Pay Periods in Desc1 column and the associated hours in Amount 1 column and earnings in Amount 2 column for each pay period.) This PL/SQL table is not used for [UEEF]. This variable name returns the internal PL/SQL Table Column 1 description.
| 358002 | Internal Table Desc2 | |Same as Internal Table Desc 1. This variable name returns Column 2 description.
| 358003 | Internal Table Desc3 | |Same as Internal Table Desc 1. This variable name returns Column 3 description.
| 358004 | Internal Table Desc4 | |Same as Internal Table Desc 1. This variable name returns Column 4 description..
| 358005 | Internal Table Desc5 | |Same as Internal Table Desc 1. This variable name returns Column 5 description
| 358011 | Internal Table Amt 1 | |Same as Internal Table Desc 1. This variable name returns Column 1 Amount.
| 358012 | Internal Table Amt 2 | |Same as Internal Table Desc 1. This variable name returns Column 2 Amount.
| 358013 | Internal Table Amt 3 | |Same as Internal Table Desc 1. This variable name returns Column 3 Amount.
| 358014 | Internal Table Amt 4 | |Same as Internal Table Desc 1. This variable name returns Column 4 Amount.
| 358015 | Internal Table Amt 5 | |Same as Internal Table Desc 1. This variable name returns Column 5 Amount.
| 358021 | Internal Total for Amt 1 | |Same as Internal Table Desc 1. This variable name returns Column 1 Total Amount.
| 358022 | Internal Total for Amt 2 | |Same as Internal Table Desc 1. This variable name returns Column 2 Total Amount.
| 358023 | Internal Total for Amt 3 | |Same as Internal Table Desc 1. This variable name returns Column 3 Total Amount.
| 358024 | Internal Total for Amt 4 | |Same as Internal Table Desc 1. This variable name returns Column 4 Total Amount.
| 358025 | Internal Total for Amt 5 | |Same as Internal Table Desc 1. This variable name returns Column 5 Total Amount.
| 358030 | UDF (EID) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_IDENTITIES] (EID)|You must define the UDF on [IMUF] screen for [P2K_HR_IDENTITIES] and then enter the value on [IEID] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field.
| 358031 | UDF (EEM) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_EMPLOYMENTS] (EEM)|You must define the UDF on [IMUF] screen for [P2K_HR_EMPLOYMENTS] and then enter the value on [IEEI] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field.
| 358032 | UDF (EASD) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|You must define the UDF on [IMUF] screen for [P2K_HR_ASSIGNMENT_DETAILS] and then enter the value on [IEAS] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field.
| 358033 | UDF (BPN) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_BE_PLAN_DEFINITIONS] (BPN)|You must define the UDF on [IMUF] screen for [P2K_BE_PLAN_DEFINITIONS] and then enter the value on [IBPN] screen section. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field.
| 358034 | UDF (EPS) (35) | |
| 358035 | UDF (DED) (35) | |
| 358036 | UDF (DDD) (35) | |
| 358037 | UDF (DLN) (35) | |
| 358038 | UDF (DUD) (35) | |
| 358039 | UDF (DGD) (35) | |
| 358040 | Element (PPH) | Indicates this Rec#/Fld# contains an Element value for the current pay header that is loaded in program|On [IDIF] screen, you should enter the Element name in the Constant Value field. This is not supported in [UBEF] because pay header is not loaded for Employee Interface.
| 358041 | Internal Element |Indicates this Rec#/Fld# contains an internal Element value that is loaded in program |On [IDIF] screen, you should enter the Element name in the Constant Value field. This is not supported in [UBEF] because Element value is not loaded for Employee Interface. A temporary internal PL/SQL table is defined for the program. The index of this PL/SQL table is made up from Rec#/Fld#, e.g. Rec#50 Fld# 60 index is 5060. The program must internally load values into this PL/SQL table by Rec#/Fld#. Then this field returns the value stored in this PL/SQL table by Rec#/Fld#. Depending on each business requirement, the program will load information into this PL/SQL table for internal purpose.
| 358042 | Statistic Amt (IEST) | Indicates this Rec#/Fld# contains a Statistics value from [P2K_HR_STATISTICS] (EST)|You must define the Statistics Code on [IDSC] screen for [P2K_CM_STATISTIC_COMPONENTS] and then enter the value on [IEST] screen. On [IDIF] screen, you must enter the [IDSC] Statistics Code in the Constant Value field
| 358043 | UDF (ECT) | |
| 358044 | UDF (BEN) | |
| 358045 | UDF (BEND) | |
| 358051 | Internal Element+UDF(EEM) |Indicates this Rec#/Fld# contains an internal Element value that is loaded in program |Value that is loaded in program. On [IDIF] screen, you should enter the Element name in the Constant Value field to be used for both the UDF (EEM) and the Internal Element. This is not supported in [UBEF] because Element value is not loaded for Employee Interface but this is supported in [UPROEF].
| 358061 | UDF(EEM)+Internal Element | Same as 358051 above. 358051 field returns the Element value, 358061 field returns the UDF(EEM) value.| This is not supported in [UBEF] because Element value is not loaded for Employee Interface.
| 359000 | Record Count | Contains Record Count for Record Type = 'Detail Record'and 'Detail Level n' records|This Record Count is available for Header and Trailer record.
| 359001 | Total Record Count | Contains Record Count for all records in the interface file excluding the Header and Trailer Record.|This Record Count is available for Header and Trailer record.
| 359002 | Total Employer Count | |Not Supported
| 359003 | Total Value (35) | |You should specify the Rec# and Field # to be totaled in [IDIF] Constant Value field (e.g. If Rec # 50 Field # 70 specifies the hours for each employee and need to be totaled for the Trailer record, then for Trailer record entry, you should specify 'Total Value' with Constant Value = 5070.) This Total Value is available for Header and Trailer records.
| 359004 | Detail Record Count (35) | Contains Record Count for Record Type = 'Detail Record', available for Header and Trailer records|
| 359005 | Detail Level 1 Count | Contains Record Count for Record Type = 'Detail Level 1', available for Header and Trailer records|
| 359006 | Detail Level 2 Count | Contains Record Count for Record Type = 'Detail Level 2', available for Header and Trailer records|
| 359007 | Detail Level 3 Count | Contains Record Count for Record Type = 'Detail Level 3', available for Header and Trailer records|
| 359008 | Detail Level 4 Count | Contains Record Count for Record Type = 'Detail Level 4', available for Header and Trailer records|
| 359009 | Detail Level 5 Count | Contains Record Count for Record Type = 'Detail Level 5', available for Header and Trailer records|
| 359010 | Employee Count (35) |Contains Total Count of unique employees in the file across Detail Record Types 'Detail Record', 'Detail Level 1', 'Detail Level 2', 'Detail Level 3', 'Detail Level 4' and 'Detail Level 5'. Available for Header and Trailer records| If an employee appears in a 'Detail Record' at Rec# 30 and can also be found in 3 additional Detail Record Types in Rec# 40,50 and 60 the employee record will only be counted as 1. If the employee is being bypassed by the BYPASS derivation or the *SKIPREC#* derivation, this record entry will not be used in the Employee Count.|
At line 1,206 added one line
This page (revision-64) was last changed on 19-Mar-2024 10:20 by Kevin HiggsTop