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

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
59 26-Nov-2021 10:22 37 KB khiggs to previous
58 26-Nov-2021 10:22 37 KB kparrott to previous | to last
57 26-Nov-2021 10:22 37 KB rforbes to previous | to last
56 26-Nov-2021 10:22 60 KB rforbes to previous | to last
55 26-Nov-2021 10:22 60 KB rforbes to previous | to last
54 26-Nov-2021 10:22 60 KB jmyers to previous | to last
53 26-Nov-2021 10:22 60 KB jmyers to previous | to last
52 26-Nov-2021 10:22 60 KB jmyers to previous | to last
51 26-Nov-2021 10:22 65 KB jmyers to previous | to last
50 26-Nov-2021 10:22 67 KB jmyers to previous | to last
49 26-Nov-2021 10:22 67 KB jmyers to previous | to last
48 26-Nov-2021 10:22 64 KB jmyers to previous | to last
47 26-Nov-2021 10:22 64 KB jmyers to previous | to last
46 26-Nov-2021 10:22 64 KB jmyers to previous | to last
45 26-Nov-2021 10:22 64 KB jmyers to previous | to last
44 26-Nov-2021 10:22 63 KB jmyers to previous | to last
43 26-Nov-2021 10:22 67 KB jmyers to previous | to last
42 26-Nov-2021 10:22 67 KB jmyers to previous | to last
41 26-Nov-2021 10:22 67 KB jmyers 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 Personality and used for UPPHF Pay History Interface.
The following lexicons are provided by [{$applicationname}] 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 (32)]
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.
At line 20 added 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 |From Pay Header assignment [Department Code|DEPARTMENT_CODE] on [P2K_CM_DEPARTMENTS] or Pay Line [Department Code|DEPARTMENT_CODE] if exists |
| 320210 | Department Name | 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 | From Pay Header assignment [Job Code|JOB_CODE] on [P2K_CM_JOBS] or Pay Line [Job Code|JOB_CODE] if exists|
| 320212 | Job Title | 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 | From Pay Header assignment [Position Code|POSITION_CODE] on [P2K_CM_POSITIONS] or Pay Line [Position Code|POSITION_CODE] if exists|
| 320214 | Position Title | 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 | From Pay Header [assignment Code|ASSIGNMENT_CODE] on [P2K_HR_ASSIGNMENTS] or Pay Line [assignment Code|ASSIGNMENT_CODE] if exists|
| 320216 | Assignment Title | From Pay Header [assignment Title|ASSIGNMENT_TITLE] on [P2K_HR_ASSIGNMENT_DETAILS] or Pay Line assignment Code Title if exists|
| 320217 | Pay Category Code | From Pay Header [pay_category_code|PAY_CATEGORY_CODE] on [P2K_PR_PAY_CATEGORIES]|
| 320218 | Check Number | From Pay Header [Check Number|CHECK_NUMBER] on [P2K_PR_CHECKS]|
| 320219 | Check Amount | From Pay Header [Check Amount|CHECK_AMOUNT] on [P2K_PR_CHECKS]|
| 320220 | User Name | From Pay Header [User Name|MUS_ID] on [P2K_AM_USERS] |
| 320221 | Work State/Prov |From Pay Header [Work State/Prov|DSP_ID_WORK] on [P2K_PR_PAY_HEADERS] |
| 320222 | Res State/Prov | From Pay Header [Residence State/Prov|DSP_ID_HOME] on [P2K_PR_PAY_HEADERS]|
| 320223 | Work GEO Code | From Pay Header [Work Jurisdiction GEO Code|GEO_CODE] on [P2K_CM_TAX_JURISDICTIONS]|
| 320224 | Res GEO Code | From Pay Header [Residence Jurisdiction GEO Code|DTX_ID_HOME] on [P2K_CM_TAX_JURISDICTIONS]|
| 320225 | Work Jurisdiction |From Pay Header [Work Jurisdiction| DTX_ID_WORK] on [P2K_PR_PAY_HEADERS]|
| 320226 | Res Jurisdiction | From Pay Header [Residence Jurisdiction|DTX_ID_HOME] on [P2K_PR_PAY_HEADERS]|
| 320227 | School District | From Pay Header [School District|DSD_ID] on [P2K_PR_PAY_HEADERS]|
| 320230 | Std Wage (eas) | From Pay Header [Assignment Std Wage|STD_WAGE_RATE]|
| 320231 | Wage Basis (eas) |From Pay Header [Assignment Wage Basis|STD_WAGE_RATE_BASIS] |
| 320232 | Authorization Code |Authorization area is from pay header or pay line's assignment, then position, then department|
| 320300 | PC Code | |The [PC Code|PC_CODE] of the current pay line detail or pay amount
| 320301 | PC Abbrev | |The [PC Abbreviation|PC_ABBREVIATION] of the current pay line detail or pay amount
| 320302 | PC Amount | |The [PC Amount|AMOUNT] of the current pay line detail or pay amount
| 320303 | Element Code | |You should specify the '[Element Code|ELEMENT_CODE]' in [IDIF] Constant Value
| 320304 | Element PC Value | |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| |You should specify the '[Element Code|ELEMENT_CODE]' in [IDIF] Constant Value
| 320306 | Element pph Value | 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) |From Pay Line [Start Date|START_DATE] on [P2K_PR_PAY_LINES] |
| 320401 | Time (ppl) | From Pay Line [Time|TIME_ENTERED] on [P2K_PR_PAY_LINES]|
| 320402 | Time Basis (ppl) |From Pay Line [Time Basis|TIME_BASIS] on [P2K_PR_PAY_LINES] |
| 320403 | Std Wage (ppl) | From Pay Line [Std Wage|STD_WAGE_RATE] on [P2K_PR_PAY_LINES]|
| 320404 | Wage Basis (ppl) |From Pay Line [Wage Basis|STD_WAGE_RATE_BASIS] on [P2K_PR_PAY_LINES] |
| 320405 | Cost Center (ppl) |From Pay Line [Cost Center|COST_CENTER_CODE] on [P2K_CM_COST_CENTERS] |
| 320406 | Cost Center Desc | From Pay Line [Cost Center description|DESCRIPTION] on [P2K_CM_COST_CENTERS]|
| 320407 | Work Order (ppl) | From Pay Line [Work Order|WORK_ORDER] on [P2K_PR_PAY_LINES]|
| 320408 | Reference Info (ppl) |From Pay Line [Reference Info|REFERENCE_INFO] on [P2K_PR_PAY_LINES] |
| 320409 | Tran Pointer (ppl) | From Pay Line [Transaction Pointer|TRANSACTION_POINTER] on [P2K_PR_PAY_LINES]|
| 320410 | Pay Line ID (ppl_id) |From [Pay Line ID|PPL_ID] |
| 320411 | Pay Line Detail (ppld_id) |From [Pay Line Detail ID|PPLD_ID] |
| 320500 | Wage Rate (ppld) | From Pay Line Detail [Wage Rate|WAGE_RATE] on [P2K_PR_PAY_LINE_DETAILS]|
| 320501 | Rate Basis (ppld) | From Pay Line Detail [Rate Basis|RATE_BASIS] on [P2K_PR_PAY_LINE_DETAILS]|
| 320502 | Tran Pointer (ppld) | From Pay Line Detail [Transaction Pointer|TRANSACTION_POINTER] on [P2K_PR_PAY_LINE_DETAILS]|
| 320600 | Total Value | |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| | 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 | |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 | |Indicates this Rec#/Fld# will invoke a UserCalc.\\ \\You should enter the UserCalc Name in the Constant Value field \\ \\Please read [User Calc section|
| 320604 | 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 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 | |Indicates this Rec#/Fld# is for XML End tag\\ \\See 320604- XML Begin tag for detail
| 320606 | UDF (EID)| |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)| |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)| |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)| |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.\\ \\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)| |Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_ENTITY_DETAILS] (DED).\\ \\You 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)| |Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_DEPARTMENT_DETAILS] (EASD).\\ \\You must define the UDF on [IMUF] screen for [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)| |Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_LOCATIONS] (DLN).\\ \\You 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)| |Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_UNIT_DETAILS] (DUD).\\ \\You 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)| |Indicates this Rec#/Fld# contains a UDF value from [P2K_CM_GROUP_DETAILS] (DGD).\\ \\You 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)| |Indicates this Rec#/Fld# contains a UDF value from [P2K_PR_PAY_RUNS] (PRN).\\ \\You 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)| |Indicates this Rec#/Fld# contains a UDF value from [P2K_PR_PAY_LINES] (PPL).\\ \\You 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)| |
| 320650 | 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.\\ \\On [IDIF] screen, you must enter the [IDSC] Statistics Code in the Constant Value field
| 320700 | Journal Entry ID (PJE)| |This field holds the [id|PJE_ID] of the current Journal Entry.
| 320701 | Distr Code (PJE) | From [Distribution Code|DISTRIBUTION_CODE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320702 | Journal Source (PJE)| From [Journal Source|JOURNAL_SOURCE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320703 | G/L Post Number (PJE) | From [GL Post Number|GLPOST_NUMBER]on [P2K_PR_JOURNAL_ENTRIES]|
| 320704 | G/L Post Seq (PJE) | From [GL Post Sequence|GLPOST_SEQUENCE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320705 | Trial Journal (PJE)| From [Trial Journal|TRIAL_JOURNAL] on [P2K_PR_JOURNAL_ENTRIES]|
| 320750 | Journal Detail ID (PJD)| |This field holds the [id|PJD_ID] of the current Journal Detail.
| 320751 | Pay Line ID (PJD)| |This field holds the [PPL_ID] of the current Journal Detail.
| 320752 | Pay Detail ID (PJD)| |This field holds the [PPLD_ID] of the current Journal Detail.
| 320753 | Pay Trans ID (PJD)| |This field holds the [PTR_ID] of the current Journal Detail.
| 320754 | G/L Fund ID (PJD) | |This field holds the [DGF_ID] of the current Journal Detail.
| 320755 | Time Code PTRC_ID (PJD) | |This field holds the [PTRC_ID] of the current Journal Detail.
| 320756 | G/L Eff Date (PJD) | From [GL Effective Date|GL_EFFECTIVE_DATE] on [P2K_PR_JOURNAL_DETAILS]|
| 320757 | G/L Amount (PJD)| From [GL Amount|GL_AMOUNT] on [P2K_PR_JOURNAL_DETAILS]|
| 320758 | G/L Amt DR (PJD) | From [GL Amount|GL_AMOUNT] if amount is positive, otherwise 0|
| 320759 | G/L Amt CR (PJD)| From [GL Amount|GL_AMOUNT] if amount is negative,otherwise 0|
| 320760 | G/L Amt-Financial (PJD) | 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) | 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) | 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) | 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)| 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)| 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) | From [Split Percent|SPLIT_PERCENT] on [P2K_PR_JOURNAL_DETAILS]|
| 320781 | G/L Detail Seq (PJD) |From [GL Detail Sequence|GL_DETAIL_SEQUENCE] on [P2K_PR_JOURNAL_DETAILS] |
| 320782 | Work Order (PJD) | From [Work Order|WORK_ORDER] on [P2K_PR_JOURNAL_DETAILS]|
| 320783 | G/L Pointer (PJD) |From [GL Pointer|GL_POINTER] on [P2K_PR_JOURNAL_DETAILS] |
| 320800 | G/L Account ID (DGA)| |This field holds the [id|DGA_ID] of the G/L Account of current journal entry|
| 320801 | G/L Account Code (DGA)| From [GL Account Code|GL_ACCOUNT_CODE] on [P2K_CM_GL_ACCOUNTS] of current G/L Account|
| 320802 | 0802 Account Type (DGA)| From [GL Account Type|ACCOUNT_TYPE] on [P2K_CM_GL_ACCOUNTS] of current G/L Account|
| 320803 | Journal Type (DGA)| From [Journal Type|JOURNAL_TYPE] on [P2K_CM_GL_ACCOUNTS]|
| 320804 | 0804 Account Usage (DGA)|From [Account Usage|ACCOUNT_USAGE] on [P2K_CM_GL_ACCOUNTS] |
| 320805 | 0805 Account Desc (DGA) | From [Account Desc|DESCRIPTION] on [P2K_CM_GL_ACCOUNTS]|
| 320806 | Distr Mask (DGA)| From [Distribution Mask|DISTRIBUTION_MASK] on [P2K_CM_GL_ACCOUNTS]|
| 320807 | Affects Costing (DGA)|From [Affects Costing|AFFECTS_COSTING] on [P2K_CM_GL_ACCOUNTS] |
| 320808 | Pre Payroll (DGA) | From [Pre Payroll|PRE_PAYROLL] on [P2K_CM_GL_ACCOUNTS]|
| 320809 | Post Payroll (DGA)|From [Post Payroll|POST_PAYROLL] on [P2K_CM_GL_ACCOUNTS] |
| 320810 | Retain Detail (DGA)|From [Retain Detail|RETAIN_DETAIL] on [P2K_CM_GL_ACCOUNTS] |
| 320811 | Accrued Required (DGA)|From [Accrued Required|ACCRUAL_REQUIRED] on [P2K_CM_GL_ACCOUNTS] |
| 320812 | I/C Required (DGA)| From [I/C Required|INTERCOMPANY_REQUIRED] on [P2K_CM_GL_ACCOUNTS]|
| 320813 | Posting Date Method (DGA) |From [Posting Date Method|POSTING_DATE_METHOD] on [P2K_CM_GL_ACCOUNTS] |
| 320814 | G/L Acct Suffix (DGA)| From [GL Acct Suffix|GL_ACCOUNT_SUFX]on [P2K_CM_GL_ACCOUNTS]|
| 320815 | Acct Charge To (DGA)| From [Acct Charge To|ACCOUNT_CHARGE_TO] on [P2K_CM_GL_ACCOUNTS]|
| 320900 | Pay Component ID (PPC)| |This field holds the [id|PPC_ID] of the Pay Component of current journal detail |
| 320901 | PC Code (PPC)| From [PC Code|PC_CODE] on [P2K_PR_PAY_COMPONENTS]|
| 320902 | PC Abbrev (PPC)|From [PC Abbreviation|PC_ABBREVIATION] on [P2K_PR_PAY_COMPONENTS] |
| 320903 | PC Desc (PPC)| From [PC Description|DESCRIPTION] on [P2K_PR_PAY_COMPONENTS]|
| 320904 | PC Action (PPC)|From [PC Action|PC_ACTION] on [P2K_PR_PAY_COMPONENTS] |
| 320905 | Store Results (PPC)|From [Store Results|STORE_RESULTS] on [P2K_PR_PAY_COMPONENTS] |
| 320920 | PC Usage ID (PCU) | | 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)| From [PC Usage Code|PC_USAGE_CODE] on [P2K_PR_PC_USAGES]|
| 320922 | PC Usage Type (PCU)| From [PC Usage Type|PC_USAGE_TYPE] on [P2K_PR_PC_USAGES]|
| 320923 | PC Usage Desc (PCU)| From [PC Usage Description|DESCRIPTION] on [P2K_PR_PC_USAGES]|
| 320924 | Unique Item (PCU) | From [Unique Item|UNIQUE_ITEM] on [P2K_PR_PC_USAGES]|
| 320925 | Mandatory (PCU) | From [Mandatory|MANDATORY] on [P2K_PR_PC_USAGES]|
| 320926 | Legislation (PCU)| From [Legislation|LEGISLATION] on [P2K_PR_PC_USAGES] |
| 320927 | PC G/L Type (PCU)|From [PC GL Type|PC_GL_TYPE] on [P2K_PR_PC_USAGES] |
| 321000 | Pays Per Year (PPP)| |
At line 33 changed 2 lines
;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
;File Name:Specifies the default file name, otherwise file name is entered on UPPHF parameter
;File Creation Number:Not used
At line 202 changed one line
[UPPHF_04.JPG]
At line 204 removed 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 removed one line
[UPPHF_05.JPG]
At line 208 changed one line
!P2K Internal Functions with Parameters
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 210 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 removed 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 removed 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 removed 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 removed one line
[UPPHF_06.JPG]
At line 222 changed one line
User may perform some internal arithmetic calculation in the derivation expression to return some prorated amount.
!P2K Internal Functions with Parameters
At line 224 removed one line
((Value of a PC in 'HOURS OT' element / Value of 'HOURS OT' Element)* Benefit Element 'HOURS COMP TIME')
At line 226 changed one line
[UPPHF_07.JPG]
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:
At line 228 changed one line
!XML File format
#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 230 changed one line
[UPPHF_08.JPG]
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 ~
At line 232 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 removed one line
You should use (Copy Definition) to copy into a different Interface Code and then enter their own company data.
At line 236 changed one line
Please refer to IDIF Fixed File Format for details of field description.
User may perform some internal arithmetic calculation in the derivation expression to return some prorated amount.
At line 238 changed one line
The Beginning and Ending positions are not needed for xml file format.
Value of a PC in ‘HOURS O/T’ element * Benefit Element ‘HOURS COMP TIME’
Value of ‘HOURS O/T’ Element
At line 240 changed 2 lines
!!IDIF - Call User Calc
!Call User Calc Function
At line 243 removed one line
You can call User Calc function at each Record Number, each Field Number
At line 245 changed one line
You should set up Variable Name = 'User Calc', and specify the User Calc name in the Constant Value field
!XML File format
At line 247 changed one line
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
- 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
At line 249 removed 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 253 changed 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. You may reference these UDFs in [IDIF] to prevent the same information from being processed again.
!!IDIF – Call User Calc
!Call User Calc function
At line 256 changed one line
You can also update the [File Creation Number|FILE_CREATION_NUMBER] on an Update Record indicating that variable and the derivation expression to {{{~ + 1}}}
- 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
At line 258 changed one line
On the [IDIF] screen, Record Type '92-Update Record' should be defined at the end of the [IDIF] definition
- 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 423 added 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 261 changed one line
The Variable Name should contain the UDF (xxx) that is to be updated or inserted,e.g. '320629 - UDF (PRN) (32)'
You may reference these UDFs in [IDIF] to prevent the same information from being processed again.
At line 428 added 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 265 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 268 changed 6 lines
*Multiple fields processing
*DECODE
*BYPASS
*String manipulation
*Concatenation
*Function calls, etc.
* multiple fields processing, DECODE, BYPASS, string manipulation, concatenation, function calls, etc.
At line 284 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 286 changed 3 lines
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 304 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 469 added 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 313 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 removed 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 404 changed 3 lines
||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.
__Record Type__: Interface File Record
At line 408 changed 2 lines
In this way you may generate interface records in following sequence:
;:''....
__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:
At line 414 changed one line
;:''....
At line 420 changed one line
;:.''....etc''
;:.'' etc''
At line 425 changed 5 lines
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
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.
At line 431 removed 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 440 changed 11 lines
|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.
|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.
At line 648 added one line
At line 461 changed one line
|Payroll| This is an optional field. Multiple 'Payroll Code' filters are allowed to be entered.
|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.
At line 662 added 54 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’
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
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
This page (revision-59) was last changed on 26-Nov-2021 10:22 by khiggsTop