This page (revision-12) was last changed on 26-Nov-2021 10:22 by khiggs

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

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
12 26-Nov-2021 10:22 26 KB khiggs to previous
11 26-Nov-2021 10:22 26 KB khiggs to previous | to last
10 26-Nov-2021 10:22 26 KB rforbes to previous | to last
9 26-Nov-2021 10:22 24 KB rforbes to previous | to last
8 26-Nov-2021 10:22 24 KB RForbes to previous | to last
7 26-Nov-2021 10:22 24 KB JEscott to previous | to last
6 26-Nov-2021 10:22 24 KB JEscott to previous | to last
5 26-Nov-2021 10:22 23 KB JEscott to previous | to last
4 26-Nov-2021 10:22 21 KB JEscott to previous | to last
3 26-Nov-2021 10:22 15 KB JEscott to previous | to last
2 26-Nov-2021 10:22 10 KB JEscott to previous | to last
1 26-Nov-2021 10:22 6 KB RForbes to last

Page References

Incoming links Outgoing links
X_INF_VARIABLE_NAME (32)
X_INF_VARIABLE_NAME (32)

Version management

Difference between version and

At line 14 changed 7 lines
| 320008 | Employment eem_id (32) | This field holds the id of the current employment record|
| 320009 | Identity eid_id (32) | This field holds the id of the current identity record|this can be used in the derivation expression to call some internal [{$applicationname}] functions that needed the [EID_ID]
| 320010 | Person Code (32) | From Employee eid.person_code|
| 320011 | First Name (32) | From Employee eid.first_name|
| 320012 | Last Name (32) | From Employee eid.last_name|
| 320013 | First,Last Name (32) |From Employee eid.first_name ', ' eid.last_name |
| 320014 | Last,First Name (32) | From Employee eid.last_name ', ' eid.first_name|
| 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 [{$applicationname}] 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]|
At line 22 changed 14 lines
| 320020 | Batch Number (32) | From Pay Header Batch pbt.batch_number|
| 320030 | Pay Run Number (32) |From Pay Run prn.pay_run_number |
| 320031 | Pay Run Sequence (32) |From Pay Header pph.pay_run_sequence |
| 320040 | Hired Date (32) | From Employment eem.hire_date|
| 320041 | Term Date (32) | From Employment eem.termination_date|
| 320042 | Seniority Date (32) |From Employment eem.seniority_date |
| 320043 | First Work Date (32) |From Employment eem.first_work_date |
| 320044 | Last Work Date (32) | From Employment eem.last_work_date|
| 320100 | Pay Header Stage | From Pay Header pph.pay_header_stage|
| 320101 | Pay Number (32) | From Pay Header pph.pay_number|
| 320102 | Pay Period (32) | From Pay Header ppp.pay_period|
| 320103 | Pay Period Start (32) |From ppp.pay_period_start_date of the pay header |
| 320104 | Pay Period End Date (32) |From ppp.pay_period_end_date of the pay header |
| 320105 | Pay Issue Date (32) | From Pay Header pph.pay_issue_date|
| 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]|
At line 42 changed 30 lines
| 320200 | G/L Company Code (32) | From GL Company Code of Pay Header Entity|
| 320201 | Entity Code (32) | From Pay Header Entity Code|
| 320202 | Entity Name (32) | From Pay Header Entity Name|
| 320203 | Payroll Code (32) |From Pay Header Payroll Code |
| 320204 | Payroll Desc (32) | From Pay Header Payroll description|
| 320205 | Unit Code (32) | From Pay Header Unit Code|
| 320206 | Unit Name (32) | From Pay Header Unit Name|
| 320207 | Group Code (32) | From Pay Header Group Code |
| 320208 | Group Desc (32) | From Pay Header Group Description|
| 320209 | Department Code (32) |From Pay Header assignment Department Code or Pay Line Department Code if exists |
| 320210 | Department Name (32) | From Pay Header assignment Department Code Name or Pay Line Department Code name if exists|
| 320211 | Job Code (32) | From Pay Header assignment Job Code or Pay Line Job Code if exists|
| 320212 | Job Title (32) | From Pay Header assignment Job Code Title or Pay Line Job Code Title if exists|
| 320213 | Position Code (32) | From Pay Header assignment Position Code or Pay Line Position Code if exists|
| 320214 | Position Title (32) | From Pay Header assignment Position Code Title or Pay Line Position Code Title if exists|
| 320215 | Assignment Code (32) | From Pay Header assignment Code or Pay Line assignment Code if exists|
| 320216 | Assignment Title (32) | From Pay Header assignment Code Title or Pay Line assignment Code Title if exists|
| 320217 | Pay Category Code (32) | From Pay Header pay_category_code|
| 320218 | Check Number (32) | From Pay Header Check Number|
| 320219 | Check Amount (32) | From Pay Header Check Amount|
| 320220 | User Name (32) | From User Name of Pay Header|
| 320221 | Work State/Prov (32) |From Pay Header Work State/Prov |
| 320222 | Res State/Prov (32) | From Pay Header Residence State/Prov|
| 320223 | Work GEO Code (32) | From Pay Header Work Jurisdiction GEO Code|
| 320224 | Res GEO Code (32) | From Pay Header Residence Jurisdiction GEO Code|
| 320225 | Work Jurisdiction (32) |From Pay Header Work Jurisdiction |
| 320226 | Res Jurisdiction (32) | From Pay Header Residence Jurisdiction|
| 320227 | School District (32) | From Pay Header School District|
| 320230 | Std Wage (eas) (32) | From Pay Header Assignment Std Wage|
| 320231 | Wage Basis (eas) (32) |From Pay Header Assignment Wage Basis |
| 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] |
At line 73 changed 6 lines
| 320300 | PC Code (32) |The PC Code of the current pay line detail or pay amount |
| 320301 | PC Abbrev (32) |The PC Abbreviation of the current pay line detail or pay amount |
| 320302 | PC Amount (32) | The PC Amount of the current pay line detail or pay amount|
| 320303 | Element Code (32) |You should specify the 'Element Code' in [IDIF] Constant Value |
| 320304 | Element PC Value (32) | You should specify the 'Element Code' in [IDIF] Constant Value|If the PC Code of the current pay line detail or pay amount is in the element, then the PC Amount is included
| 320305 | Element Desc (32) |You should specify the 'Element Code' in [IDIF] Constant Value |
| 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 |
At line 105 changed 2 lines
| 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
| 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
At line 110 changed 2 lines
| 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
| 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
This page (revision-12) was last changed on 26-Nov-2021 10:22 by khiggsTop