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

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
27 26-Nov-2021 10:22 51 KB kparrott to previous
26 26-Nov-2021 10:22 50 KB jmyers to previous | to last
25 26-Nov-2021 10:22 53 KB jmyers to previous | to last
24 26-Nov-2021 10:22 53 KB jmyers to previous | to last
23 26-Nov-2021 10:22 52 KB jmyers to previous | to last
22 26-Nov-2021 10:22 50 KB jmyers to previous | to last
21 26-Nov-2021 10:22 50 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
X_INF_VARIABLE_NAME (35)
X_INF_VARIABLE_NAME (35)

Version management

Difference between version and

At line 7 changed 8 lines
| 350001 | XML Begin Tag | |Indicates this Rec#/Fld# is for XML Begin tag. User should enter the XML tag in the XML tag field, if XML tag is not specified, the field name is used as XML Tag. User 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. User should match XML End tag to XML Begin tag on [IDIF] definition
| 350003 | Constant Value | | Indicates this Rec#/Fld# contains a constant. User 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 As Of Date parameter|
| 350006 | Execution ID| From the function's 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
| 350008 | Trial Run | |
| 350001 | XML Begin Tag (35) | |Indicates this Rec#/Fld# is for XML Begin tag. User should enter the XML tag in the XML tag field, if XML tag is not specified, the field name is used as XML Tag. User should specify XML tag option. If XML tag option is not specified, this XML tag is an optional tag
| 350002 | XML End Tag (35) | |Indicates this Rec#/Fld# is for XML End tag. Same logic as XML Begin tag. User should match XML End tag to XML Begin tag on [IDIF] definition
| 350003 | Constant Value (35) | | Indicates this Rec#/Fld# contains a constant. User should enter the constant in Constant Value field
| 350004 | System Date/Time (35) | 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 (35) | From the As Of Date parameter|
| 350006 | Execution ID (35) | From the function's Execution ID of the run|
| 350007 | User Calc (35) | |Indicates this Rec#/Fld# will invoke a UserCalcUserCalc . You should enter the UserCalc name in the Constant Value field, e.g. BE USERCALC
| 350008 | Trial Run (35) | |
At line 25 changed one line
| 350103 | G/L Company (DEN) |From [P2K_CM_ENTITIES] (DEN) GL Company id to retrieve [GL Company code|GL_COMPANY_CODE] |
| 350103 | G/L Company (DEN) (35) |From [P2K_CM_ENTITIES] (DEN) GL Company id to retrieve [GL Company code|GL_COMPANY_CODE] |
At line 125 changed one line
| 350801 | Govt Regist dgv_id |From [P2K_CM_GOVT_REGISTRATIONS] (DGV) |
| 350801 | Govt Regist dgv_id (35) |From [P2K_CM_GOVT_REGISTRATIONS] (DGV) |
At line 128 changed 3 lines
| 353100 | Person Code (EID) | [P2K_HR_IDENTITIES] (EID) is retrieved for the employee|This field returns the [Person code|PERSON_CODE] from [EID].
| 353101 | Person eid_id (EID) | From [P2K_HR_IDENTITIES] (EID)|this field returns the eid.id, user may use this id in 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 | Government Code (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 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)|
At line 146 changed one line
| 353134 | Veteran Status (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353134 | Vetern Status (EID) | From [P2K_HR_IDENTITIES] (EID)|
At line 152 changed one line
| 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]
| 353200 | Personal eps_id (EPS) |[P2K_HR_PERSONALS] (EPS) is retrieved for the employee effective as of the 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]
At line 158 changed 2 lines
| 353206 | Address 2 + Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Address Line 2 and Locality (city) are concatenated
| 353207 | Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353206 | Address 2 + City (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Address Line 2 and Locality (city) are concatenated
| 353207 | City (EPS) | From [P2K_HR_PERSONALS] (EPS)|
At line 168 changed 2 lines
| 353222 | Mail Ln2 + 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)|
| 353222 | Mail Adr 2 + City (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Mailing Address Line 2 and Locality (city) are concatenated
| 353223 | Mail City (EPS) | From [P2K_HR_PERSONALS] (EPS)|
At line 172 changed one line
| 353226 | Mail Zip Postal (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353226 | Mail Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|
At line 206 changed one line
| 353380 | Term Description (DTR) | [P2K_CM_TERMINATION_REASONS] (DTR) is retrieved from the employee's Employment|This field returns the [Termination description|DESCRIPTION] of DTR
| 353380 | Term Description (DTR) | [P2K_CM_TERMINATION_REASONS] (DTR) is retrieved from the employee's Employment|This field returns the [Termination description|DESCRIPTION]
At line 211 changed 6 lines
| 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 [UPROEF] program internal ROE Reason issue
| 353395 | ROE process meth (ROE) |From [UPROEF] program internal Process method|
| 353390 | Pay Frequency (ROE) | From [IPCL]'s [PAY_FREQUENCY] first character or [IPCL] UDF '[ROE PAY FREQUENCY (UDF)]'| Used by [UPROEF]
| 353391 | First day worked (ROE) | From [IEEI] UDF '[Override ROE 1st Work Date|OVD ROE 1st WORK DATE (UDF)]' if specified, otherwise from EEM [FIRST_WORK_DATE]. If employee has issued ROE before (i.e. [IEEI] UDF [Prev ROE Upto|PREV ROE UPTO (UDF)] is not null), then the First Day Worked is retrieved from the earliest pay line start_date of the first Regular Pay Header that is with pay period after '[Prev ROE Upto|PREV ROE UPTO (UDF)]' pay period|Used by [UPROEF]
| 353392 | Last day paid (ROE) | From [IEEI] UDF '[OVD ROE Last Work Date|OVD ROE LAST WORK DATE (UDF)]' if specified, otherwise from EEM [last work date|LAST_WORK_DATE]|Used by [UPROEF]
| 353393 | Final period end (ROE) |From Last pay period end date being paid |Used by [UPROEF]
| 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 |
At line 231 changed one line
| 353500 | Assignment easd_id (EASD) | [P2K_HR_ASSIGNMENT_DETAILS] (EASD) is retrieved for the employee's Primary Assignment effective as of the [UEEF] 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]
| 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]
At line 253 changed one line
| 353522 | FTE (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353522 | Fte (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
At line 260 changed one line
| 353529 | Use FTE Wages (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353529 | Use Fte Wages (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
At line 271 changed one line
| 353540 | WCB Class (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353540 | WC Class (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
At line 282 changed one line
| 353602 | Effective (PPRU) |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 UEEF As of Date parameter|
| 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)|
At line 312 changed 5 lines
| 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 WCB 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)|
At line 336 changed one line
| 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 [UEEF] As of Date parameter|
| 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|
At line 348 changed 2 lines
| 353713 | Cfed CPP Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353714 | Cfed EI 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)|
At line 351 changed 11 lines
| 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 WCB Method (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)|
At line 366 changed 3 lines
| 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 [UEEF] Interface Level parameter = '02 - EEM + EASD + Contacts', [P2K_HR_CONTACTS] (ECT) is retrieved for the employee's Identity (EID). If the [UEEF] 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)
| 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)
At line 386 changed one line
| 353819 | Addr Ln2 + Locality(ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address Line 2 and Locality (city) are concatenated
| 353819 | Addr Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address Line 2 and Locality (city) are concatenated
At line 391 changed one line
| 353824 | State+Cntry+Postal (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address State/Prov, Country and Postal Code are concatenated
| 353824 | State+Cntry+Zip (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address State/Prov, Country and Postal Code are concatenated
At line 394 changed 3 lines
| 353827 | Mail Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Mailing Address Line 2 and Locality (city) are concatenated
| 353828 | Mail Locality (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353829 | Mail State Province (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)|
At line 398 changed 2 lines
| 353831 | Mail Zip Postal (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
| 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
At line 413 changed 2 lines
| 355001 | Enrollment id (BEN) |[P2K_BE_ENROLLMENTS] (BEN) |If the [UEEF]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 [UEEF] parameter. This 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 [UEEF] 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].
| 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]
At line 460 changed one line
| 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|P2K_BE_COVERAGES (BCG) is retrieved for this Enrollment Detail BEND.bcg_id//This field returns the [BCG_ID], you may use this id in derivation expression to return other value that is related to [BCG_ID]
| 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]
At line 466 changed one line
| 355401 | Covg Detail id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD) effective as of the [UEEF] As of Date parameter|
| 355401 | Covg Detail id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD) effective as of the As of Date parameter|
At line 488 changed one line
| 355601 | Ben Recip id (BBR) |From [P2K_BE_BENEFIT_RECIPIENTS] (BBR) |If the [UEEF] Interface Level parameter = '04 - BE Plans + Contacts', [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]
| 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]
At line 494 changed 53 lines
| 358001 | Internal Table Desc1 | |A temporary internal PL/SQL table is defined for the Generic Interface Program. This PL/SQL table holds up to 5 columns information. Each column has a description and an amount. 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) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_IDENTITIES] (EID)|User 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, the user does not need to set up UDF on IMUF screen
| 358031 | UDF (EEM) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_EMPLOYMENTS] (EEM)|User 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, the user does not need to set up UDF on IMUF screen
| 358032 | UDF (EASD) | 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-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
| 358033 | UDF (BPN) | Indicates this Rec#/Fld# contains a UDF value from [P2K_BE_PLAN_DEFINITIONS] (BPN)|User must define the UDF on [IMUF] screen for [P2K_BE_PLAN_DEFINITIONS] and then enter the value on [IBPN] screen section.\\On [IDIF] screen, 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.
| 358034 | UDF (EPS) |- indicates this Rec#/Fld# contains a UDF value from P2K_HR_PERSONALS (EPS) |- user must define the UDF on IMUF screen for P2K_HR_PERSONALS and then enter the value on IEPI screen\\- on IDIF screen, 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
| 358035 | UDF (DED) |- 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\\- on IDIF screen, 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
| 358036 | UDF (DDD) |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_DEPARTMENT_DETAILS (DDD) |- user must define the UDF on IMUF screen for P2K_CM_DEPARTMENT_DETAILS and then enter the value on IDDP screen\\- on IDIF screen, 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
| 358037 | UDF (DLN) |- 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, 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
| 358038 | UDF (DUD) (35) |- 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\\- on IDIF screen, 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
| 358039 | UDF (DGD) (35) | |- 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
- on IDIF screen, 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
| 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 [UEEF] 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 [UEEF] 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, e.g. UPROEF uses this table to hold element values for Box 17 Vacation Amount, Statutory Holiday Amounts etc.
| 358042 | Statistic Amt (IEST)| 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
| 358043 | UDF (ECT) |- indicates this Rec#/Fld# contains a UDF value from P2K_HR_CONTACTS (ECT) |- user must define the UDF on IMUF screen for P2K_HR_CONTACTS and then enter the value on IECT screen
- on IDIF screen, 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
| 358044 | UDF (BEN) | |- indicates this Rec#/Fld# contains a UDF value from P2K_BE_ENROLLMENTS (BEN)
- user must define the UDF on IMUF screen for P2K_BE_ENROLLMENTS and then enter the value on IBEN screen
- on IDIF screen, 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
| 358045 | UDF (BEND) |- indicates this Rec#/Fld# contains a UDF value from P2K_BE_ENROLLMENT_DETAILS (BEND)
- user must define the UDF on IMUF screen for P2K_BE_ENROLLMENT_DETAILS and then enter the value on IBEN screen
- on IDIF screen, 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
| 358051 | Internal Element+UDF(EEM) |Indicates this Rec#/Fld# contains an internal Element value that is loaded in program |- on IDIF screen, user 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 UEEF because Element value is not loaded for Employee Interface
- e.g. UPROEF
IEEI UDF: ‘ROE STATHOL1 DATE’
Element: ‘ROE STATHOL1 DAT’
- if IEEI UDF is specified and Element value <> 0, then Element value is reported, otherwise zero
| 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 up to 5 columns information. Each column has a description and an amount. 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)|User 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)|User 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)|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
| 358033 | UDF (BPN) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_BE_PLAN_DEFINITIONS] (BPN)|User must define the UDF on [IMUF] screen for [P2K_BE_PLAN_DEFINITIONS] and then enter the value on [IBPN] screen section. On [IDIF] screen, user 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) (35) | 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
| 358043 | UDF (ECT) (35) | |
| 358044 | UDF (BEN) (35) | |
| 358045 | UDF (BEND) (35) | |
| 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].
At line 548 changed 5 lines
| 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 | |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
| 359004 | Detail Record Count | Contains Record Count for Record Type = 'Detail Record', available for Header and Trailer records|
| 359000 | Record Count (35) | 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 (35) | 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 (35) | |Not Supported
| 359003 | Total Value (35) | |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
| 359004 | Detail Record Count (35) | Contains Record Count for Record Type = 'Detail Record', available for Header and Trailer records|
This page (revision-27) was last changed on 26-Nov-2021 10:22 by kparrottTop