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 3 changed one line
[X_INF_VARIABLE_NAME] is a [fixed lexicon]. Variables starting with "35" are used to define interfaces in the [IDIF] screen that will be created by the [UEEF] program (and other derivitive programs)
[X_INF_VARIABLE_NAME] is a [fixed lexicon]. Variables starting with "35" are used to define interfaces in the [IDIF] screen that will be created by the [UEEF] program (and other derivative programs)
At line 7 changed 3 lines
| 350001 | XML Begin Tag (35) | |Indicates this Rec#/Fld# is for XML Begin tag \\ You should enter the XML tag in the XML tag field, if XML tag is not specified, the field name is used as XML Tag \\ You should specify XML tag option \\ If XML tag option is not specified, this XML tag is an optional tag
| 350002 | XML End Tag (35) | |Indicates this Rec#/Fld# is for XML End tag \\ Same logic as XML Begin tag \\ You should match XML End tag to XML Begin tag on [IDIF] definition
| 350003 | Constant Value (35) | | Indicates this Rec#/Fld# contains a constant \\ You should enter the constant in Constant Value field
| 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
At line 11 changed 3 lines
| 350005 | As Of Date (35) | From [UBEF] As Of Date parameter|
| 350006 | Execution ID (35) | From [UBEF] 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
| 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
At line 22 changed 5 lines
| 350100 | Entity den_id (DEN) | [P2K_CM_ENTITIES] (DEN) is retrieved from employee's employment. |This field returns the den.id, you may use this id in derivation expression to return other value that is related to den.id e.g. to return the UDF 'COMPANY LICENCE' value from [IDEN], use derivation expression:p2k_smgetudf('P2K_CM_ ENTITIES', 'COMPANY LICENCE',~)
| 350101 | Entity Code (DEN) | From [P2K_CM_ENTITIES] (DEN) Entity Code|
| 350102 | Standing (DEN) | From [P2K_CM_ENTITIES] (DEN) Standing|
| 350103 | G/L Company (DEN) (35) |From [P2K_CM_ENTITIES] (DEN) GL Company id to retrieve GL Company code |
| 350110 | Effective (DED) | From [P2K_CM_ENTITY_DETAILS] (DED) effective as of [UEEF] As of Date parameter|
| 350100 | Entity den_id (DEN) | [P2K_CM_ENTITIES] (DEN) is retrieved from employee's employment. |This field returns the [DEN_ID], you may use this id in derivation expression to return other value that is related to [DEN_ID] e.g. to return the UDF 'COMPANY LICENCE' value from [IDEN], use derivation expression:p2k_smgetudf('P2K_CM_ ENTITIES', 'COMPANY LICENCE',~)
| 350101 | Entity Code (DEN) | From [P2K_CM_ENTITIES] (DEN) [Entity Code|ENTITY_CODE]|
| 350102 | Standing (DEN) | From [P2K_CM_ENTITIES] (DEN) [Standing|STANDING]|
| 350103 | G/L Company (DEN) (35) |From [P2K_CM_ENTITIES] (DEN) GL Company id to retrieve [GL Company code|GL_COMPANY_CODE] |
| 350110 | Effective (DED) | From [P2K_CM_ENTITY_DETAILS] (DED) effective as of the As of Date parameter|
At line 34 changed one line
| 350201 | Location Code (DLN) | [P2K_CM_LOCATIONS] (DLN) is retrieved from DED.DLN_ID|If [UEEF] parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
| 350201 | Location Code (DLN) | [P2K_CM_LOCATIONS] (DLN) is retrieved from DED.DLN_ID|If the parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
At line 63 changed one line
| 350300 | Department ddp_id (DDP) | [P2K_CM_DEPARTMENTS] (DDP) is retrieved from employee's prime assignment|This field returns the ddp.id, user may use this id in derivation expression to return other value that is related to ddp.id
| 350300 | Department ddp_id (DDP) | [P2K_CM_DEPARTMENTS] (DDP) is retrieved from employee's prime assignment|This field returns the [DDP_ID], user may use this id in derivation expression to return other value that is related to [DDP_ID]
At line 67 changed one line
| 350310 | Effective (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD) effective as of UEEF As of Date parameter|
| 350310 | Effective (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD) effective as of the As of Date parameter|
At line 80 changed one line
| 350400 | Unit dun_id (DUN) |[P2K_CM_UNITS] (DUN) is retrieved from employee's prime assignment|This field returns the dun.id, you may use this id in derivation expression to return other value that is related to dun.id
| 350400 | Unit dun_id (DUN) |[P2K_CM_UNITS] (DUN) is retrieved from employee's prime assignment|This field returns the [DUN_ID], you may use this id in derivation expression to return other value that is related to [DUN_ID]
At line 83 changed one line
| 350410 | Effective (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD) effective as of [UEEF] As of Date parameter|
| 350410 | Effective (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD) effective as of the As of Date parameter|
At line 93 changed one line
| 350500 | Group dgr_id (DGR) | [P2K_CM_GROUPS] (DGR) is retrieved from the employee's prime assignment dgr_id| This field returns the dgr.id, you may use this id in derivation expression to return other value that is related to dgr.id
| 350500 | Group dgr_id (DGR) | [P2K_CM_GROUPS] (DGR) is retrieved from the employee's prime assignment [DGR_ID]| This field returns the [DGR_ID], you may use this id in derivation expression to return other value that is related to [DGR_ID]
At line 117 changed one line
| 350601 | Payroll Code (PPA) | [P2K_PR_PAYROLLS] (PPA) is retrieved from the employee's prime assignment group details|This field returns the Payroll code from PPA
| 350601 | Payroll Code (PPA) | [P2K_PR_PAYROLLS] (PPA) is retrieved from the employee's prime assignment group details|This field returns the [Payroll code|PAYROLL_CODE] from PPA
At line 120 changed one line
| 350701 | Pay Calendar Code (PCL) | [P2K_PR_PAY_CALENDARS] (PCL) is retrieved from the employee's prime assignment group details Payroll code|This field returns the Pay Calendar code from PCL
| 350701 | Pay Calendar Code (PCL) | [P2K_PR_PAY_CALENDARS] (PCL) is retrieved from the employee's prime assignment group details [Payroll code|PAYROLL_CODE]|This field returns the [Pay Calendar code|PAY_CALENDAR_CODE] from PCL
At line 124 changed one line
| 350800 | Govt Regist Number (DGV) |[P2K_CM_GOVT_REGISTRATIONS] (DGV) is retrieved from the employee's prime assignment group details Federal Registration |This field returns the Govt Regist Number from DGV
| 350800 | Govt Regist Number (DGV) |[P2K_CM_GOVT_REGISTRATIONS] (DGV) is retrieved from the employee's prime assignment group details Federal Registration |This field returns the [Govt Regist Number|GOVT_REGIST_NUMBER] from DGV
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 from EID
| 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',~)''
| 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',~)
At line 135 changed 4 lines
| 353106 | Last, First, Middle (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: ''Last name + ',' + First name + space + Middle name e.g. Smith, Mary Beverley''
| 353107 | Last, First, Initial (EID) |From [P2K_HR_IDENTITIES] (EID)| The employee's name is returned as follows: ''Last name + ',' + First name + space + Middle Initial e.g. Smith, Mary B''
| 353108 | First, Middle, Last (EID) | From [P2K_HR_IDENTITIES] (EID)|The employee's name is returned as follows: ''First name + space + Middle name + space + Last name e.g. Mary Beverley Smith''
| 353109 | First, Initial, Last (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: ''First name + space + Middle Initial + space + Last name e.g. Mary B Smith''
| 353106 | Last, First, Middle (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: Last name + ',' + First name + space + Middle name e.g. Smith, Mary Beverley
| 353107 | Last, First, Initial (EID) |From [P2K_HR_IDENTITIES] (EID)| The employee's name is returned as follows: Last name + ',' + First name + space + Middle Initial e.g. Smith, Mary B
| 353108 | First, Middle, Last (EID) | From [P2K_HR_IDENTITIES] (EID)|The employee's name is returned as follows: First name + space + Middle name + space + Last name e.g. Mary Beverley Smith
| 353109 | First, Initial, Last (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: First name + space + Middle Initial + space + Last name e.g. Mary B Smith
At line 153 changed one line
| 353200 | Personal eps_id (EPS) |[P2K_HR_PERSONALS] (EPS) is retrieved for the employee effective as of 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 190 changed one line
| 353300 | Employment eem_id (EEM) | [P2K_HR_EMPLOYMENTS] (EEM) is retrieved for the employee|This field returns the eem.id, you may use this id in derivation expression to return other value that is related to eem.id
| 353300 | Employment eem_id (EEM) | [P2K_HR_EMPLOYMENTS] (EEM) is retrieved for the employee|This field returns the [EEM_ID], you may use this id in derivation expression to return other value that is related to [EEM_ID]
At line 207 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 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 212 changed 5 lines
| 353390 | Pay Frequency (ROE) | From [UPROEF] program internal Pay Frequency|For [UPROEF] only
| 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|
| 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]
At line 222 changed one line
| 353400 | Assignment eas_id (EAS) | [P2K_HR_ASSIGNMENTS] (EAS) is retrieved for the employee's Primary Assignment| This field returns the eas.id, you may use this id in derivation expression to return other value that is related to eas.id
| 353400 | Assignment eas_id (EAS) | [P2K_HR_ASSIGNMENTS] (EAS) is retrieved for the employee's Primary Assignment| This field returns the [EAS_ID], you may use this id in derivation expression to return other value that is related to [EAS_ID]
At line 232 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 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 241 changed 254 lines
| 353509 | Group Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353510 | Location Work In (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353511 | Location Paydest (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353512 | Authorization Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353513 | Tax Jurisdiction (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353514 | Work Calendar (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353515 | Work Rule (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353516 | Supervised By (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353517 | Replaced By (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353518 | Job Profile (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353519 | Range Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353520 | Scale Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353521 | Step Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353522 | Fte (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353523 | Assignment Title (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353524 | Hours Per Day (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353525 | Hours Per Week (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353526 | Hours Per Pay (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353527 | Wage Rate (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353528 | Rate Basis (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353529 | Use Fte Wages (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353530 | Out Of Range (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353531 | Scale Overridden (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353532 | Periods Elected (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353533 | Pay Starting Date (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353534 | Contract Days (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353535 | Contract Limit (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353536 | Job Seniority Date (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353537 | Service Rating (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353538 | Responsibility Level (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353539 | Work Type (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353540 | WC Class (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353541 | Phone Number (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353542 | Phone Extension (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353543 | Email Address (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353544 | Leave Date (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353545 | Leave Reason (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353546 | Leave Return Date (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353547 | Trigger Retro (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353548 | Provide Public Sve (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353549 | Provide Internal Sve (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353550 | Supervisory (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353551 | Job Class Lex Value | If the Entity Detail (DED) legislation is for US, P2K_PR_US_PAY_RULES (PPRU) is retrieved for the employee's Employment effective as of UEEF As of Date parameter|
| 353602 | Effective (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353603 | Expiry (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353604 | Change Code (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353605 | Ufed Filing Status (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353606 | Ufed Num Exemptions (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353607 | Ufed Ann Exemption (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353608 | Ufed Add Exemption (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353609 | Ufed Add Tax Per Prd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353610 | Ufed Tax Amount (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353611 | Ufed Tax Percent (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353612 | Ufed Tax Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353613 | Ufed Suppl Tax Mthd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353614 | Ufed Fica Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353615 | Ufed Medicare Mthd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353616 | Ufed Futa Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353617 | Ufed Eic Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353618 | Ust Reciprocation (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353619 | Ust Filing Status (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353620 | Ust Num Exemption 1 (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353621 | Ust Num Exemption 2 (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353622 | Ust Ann Exemption (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353623 | Ust Add Exemption (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353624 | Ust Add Tax Per Prd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353625 | Ust Add Tax Res (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353626 | Ust Add Tax Work (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353627 | Ust Tax Amount (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353628 | Ust Tax Percent (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353629 | Ust Tax Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353630 | Ust Suppl Tax Mthd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353631 | Ust Alt Tax Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353632 | Ust Sui Ee Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353633 | Ust Sui Er Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353634 | Ust Sdi Ee Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353635 | Ust Sdi Er Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353636 | Ust WC Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353637 | Uloc Reciprocation (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353638 | Uloc Filing Status (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353639 | Uloc Num Exemptions (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353640 | Uloc Ann Exemption (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353641 | Uloc Exempt Percent (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353642 | Uloc Add Tax Per Prd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353643 | Uloc Add Tax Work (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353644 | Uloc Add Tax Res (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353645 | Uloc Tax Amount (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353646 | Uloc Tax Percent 1 (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353647 | Uloc Tax Percent 2 (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353648 | Uloc County Tax Mthd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353649 | Uloc City Tax Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353650 | Uloc School Tax Mthd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353651 | Uloc School Tax Amt (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353652 | Uloc School Tax % (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353653 | Uloc Head Tax Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353654 | Uloc Head Tax Amount (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353655 | Ust Eic Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353701 | Effective (PPRC) | if the Entity Detail (DED) legislation is for Canada, P2K_PR_CDN_PAY_RULES (PPRC) is retrieved for the employee's Employment effective as of UEEF As of Date parameter|
| 353702 | Expiry (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353703 | Change Code (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353704 | Cfed Td1 Amount (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353705 | Cfed Ann Tax Credit (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353706 | Cfed Ann Tax Deduct (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353707 | Cfed Ann Area Deduct (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353708 | Cfed Tax Amount (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353709 | Cfed Tax Percent (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353710 | Cfed Add Tax Per Prd (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353711 | Cfed Filing Status (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353712 | Cfed Tax Method (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353713 | Cfed Cpp Method (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353714 | Cfed Ei Method (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353715 | Cfed Labour Fund (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353716 | Cprv Claim Amount (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353717 | Cprv Num Dependents (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353718 | Cprv Ann Tax Deduct (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353719 | Cprv Tax Amount (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353720 | Cprv Tax Percent (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353721 | Cprv Add Tax Per Prd (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353722 | Cprv Filing Status (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353723 | Cprv Tax Method (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353724 | Cprv Qpp Method (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353725 | Cprv Health Tax Mthd (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353726 | Cprv WC Method (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353727 | Fed Tax Claim Type (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353728 | Fed Tax Claim Code (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353729 | Prov Tax Claim Type (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353730 | Prov Tax Claim Code (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353731 | Cprv Ann Tax Credit (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353732 | Cprv Ann Area Deduct (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353801 | Contacts ect_id (ECT) |From P2K_HR_CONTACTS (ECT) |If UEEF Interface Level parameter = '02 - EEM + EASD + Contacts', P2K_HR_CONTACTS (ECT) is retrieved for the employee's Identity (EID). If 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)
| 353802 | First_name (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353803 | Middle_name (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353804 | Last_name (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353805 | Last, First, Middle (ECT) | From P2K_HR_CONTACTS (ECT)|The contact's name is returned as follows: ''Last name + ',' + First name + space + Middle name e.g. Smith, Mary Beverley''
| 353806 | Last, First, Initial (ECT) |From P2K_HR_CONTACTS (ECT) |The contact's name is returned as follows: ''Last name + ',' + First name + space + Middle Initial e.g. Smith, Mary B''
| 353807 | First, Middle, Last (ECT) | From P2K_HR_CONTACTS (ECT)|The contact's name is returned as follows: ''First name + space + Middle name + space + Last name e.g. Mary Beverley Smith''
| 353808 | Gender (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353809 | Relation (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353810 | S.S.N. (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353811 | Birth_date (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353812 | Language_code (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353813 | Salutation (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353814 | Rank (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353815 | Employer (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353816 | Contact_title (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353817 | Address_line_1 (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353818 | Address_line_2 (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353819 | Addr Ln2 + City (ECT) | From P2K_HR_CONTACTS (ECT)|Contact’s Address Line 2 and Locality (city) are concatenated
| 353820 | City (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353821 | State Code (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353822 | Country Code (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353823 | Zip Code (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353824 | State+Cntry+Zip (ECT) | From P2K_HR_CONTACTS (ECT)|Contact’s Address State/Prov, Country and Postal Code are concatenated
| 353825 | Mail_address_line_1 (ECT) |From P2K_HR_CONTACTS (ECT) |if Mailing address does not exist, the primary address will be used
| 353826 | Mail_address_line_2 (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353827 | Mail Ln2 + City (ECT) | From P2K_HR_CONTACTS (ECT)|Contact’s Mailing Address Line 2 and Locality (city) are concatenated
| 353828 | Mail City (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353829 | Mail State (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353830 | Mail Country Code (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353831 | Mail Zip Code (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353832 | Mail State+Cntry+Zip (ECT) | From P2K_HR_CONTACTS (ECT)|contact’s Mailing Address State/Prov, Country and Postal Code are concatenated
| 353833 | Phone_number (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353834 | Phone_extension (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353835 | Alt_phone_number (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353836 | Alt_phone_extn (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353837 | Cellular_number (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353838 | Fax_number (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353839 | Email_address (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353840 | Security_level (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353841 | Private_item (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353842 | Web_address (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353843 | Govt_code_origin (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353844 | Contacts eid_id (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353845 | Contacts mus_id (ECT) | From P2K_HR_CONTACTS (ECT)|
| 355001 | Enrollment id (BEN) |P2K_BE_ENROLLMENTS (BEN) |If 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. 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 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
| 355003 | Effective (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355004 | Expiry (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355005 | Unofficial (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355006 | Enrollment_status (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355007 | Participation_rule (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355008 | Coverage_step_code (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355009 | Description (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355010 | Elig_start_date (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355011 | Elig_end_date (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355012 | Prem_start_date (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355013 | Prem_end_date (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355014 | Plan_reg_number (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355015 | Evidence_of_ins (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355016 | Percentage (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355020 | Freq pfq_id (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355021 | Change reason dcr_id (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355022 | Covg bcg_id (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355023 | Orig bend_id (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355101 | Plan Type id (BPT) | From P2K_BE_ENROLLMENTS (BEN), it links to the P2K_BE_PLAN_DEFINITION (BPN) which links to P2K_BE_BENEFIT_PLAN_TYPE (BPT)| This field returns the bpt.id, you may use this id in derivation expression to return other value that is related to bpt.id
| 355102 | Plan_type_code (BPT) | From P2K_BE_BENEFIT_PLAN_TYPE (BPT)|
| 355103 | Description (BPT) | From P2K_BE_BENEFIT_PLAN_TYPE (BPT)|
| 355104 | Calc_sequence (BPT) | From P2K_BE_BENEFIT_PLAN_TYPE (BPT)|
| 355201 | Plan Defn id (BPN) | From P2K_BE_ENROLLMENTS (BEN), it links to the P2K_BE_PLAN_DEFINITION (BPN)|This field returns the bpn.id, you may use this id in derivation expression to return other value that is related to bpn.id
| 355202 | Plan_code (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355203 | Description (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355204 | Plan_access_code (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355205 | Established_date (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355206 | Participation_rule (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355207 | Policy_number (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355208 | Calc_sequence (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355209 | Plan_remit_seq (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355210 | Track_decline (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355211 | Last_remit_date (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355212 | Remit_by_state (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355213 | Remit_by_un_grp (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355214 | Remit_date_rule (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355215 | Remit_asof_day (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355216 | Print_zero_rule (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355217 | Print_all_waivers (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355218 | Not_scheduled (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355219 | Plan_end_date (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355220 | Approval_required (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355221 | Plan den_id (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355222 | Plan dcl_id (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355223 | Plan brm_id (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355301 | Coverage id (BCG) | From P2K_BE_ENROLLMENT_DETAILS (BEND) for this employee for this benefit plan, it links to the P2K_BE_COVERAGES (BCG) to indicate the coverage the employee has elected for the BE plan|This field returns the bcg.id, you may use this id in derivation expression to return other value that is related to bcg.id
| 355302 | Coverage_code (BCG) | |
| 355303 | Covg_remit_seq (BCG) | |
| 355304 | Policy_number (BCG) | |
| 355305 | Contact_role (BCG) | |
| 355306 | Covg muc_id (BCG) | |
| 355401 | Covg Detail id (BCGD) | |
| 355402 | Effective (BCGD) | |
| 355403 | Expiry (BCGD) | |
| 355404 | Remit_basis (BCGD) | |
| 355405 | Rate_basis (BCGD) | |
| 355406 | Description (BCGD) | |
| 355407 | Covg Detail pfq_id (BCGD) | |
| 355408 | Covg Detail dcr_id (BCGD) | |
| 355501 | Covg Rate id (BCGR) | |
| 355502 | Covg_step_code (BCGR) | |
| 355503 | Description (BCGR) | |
| 355504 | Up_to_limit (BCGR) | |
| 355505 | Next_step_code (BCGR) | |
| 355506 | Flex_amount (BCGR) | |
| 355507 | Premium1_rate (BCGR) | |
| 355508 | Premium2_rate (BCGR) | |
| 355509 | EE_deduct_rate (BCGR) | |
| 355510 | ER_contrib_rate (BCGR) | |
| 355511 | Taxben_rate (BCGR) | |
| 355512 | User1_rate (BCGR) | |
| 355513 | User2_rate (BCGR) | |
| 355514 | User3_rate (BCGR) | |
| 355601 | Ben Recip id (BBR) | |
| 355602 | Start_date (BBR) | |
| 355603 | End_date (BBR) | |
| 355604 | Benefit_percent (BBR) | |
| 355605 | Bond_participation (BBR) | |
| 353509 | Group Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353510 | Location Work In (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353511 | Location Paydest (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353512 | Authorization Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353513 | Tax Jurisdiction (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353514 | Work Calendar (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353515 | Work Rule (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353516 | Supervised By (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353517 | Replaced By (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353518 | Job Profile (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353519 | Range Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353520 | Scale Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353521 | Step Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353522 | Fte (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353523 | Assignment Title (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353524 | Hours Per Day (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353525 | Hours Per Week (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353526 | Hours Per Pay (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353527 | Wage Rate (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353528 | Rate Basis (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353529 | Use Fte Wages (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353530 | Out Of Range (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353531 | Scale Overridden (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353532 | Periods Elected (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353533 | Pay Starting Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353534 | Contract Days (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353535 | Contract Limit (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353536 | Job Seniority Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353537 | Service Rating (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353538 | Responsibility Level (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353539 | Work Type (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353540 | WC Class (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353541 | Phone Number (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353542 | Phone Extension (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353543 | Email Address (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353544 | Leave Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353545 | Leave Reason (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353546 | Leave Return Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353547 | Trigger Retro (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353548 | Provide Public Sve (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353549 | Provide Internal Sve (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353550 | Supervisory (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353551 | Job Class Lex Value | If the Entity Detail (DED) legislation is for US, [P2K_PR_US_PAY_RULES] (PPRU) is retrieved for the employee's Employment effective as of the As of Date parameter|
| 353602 | Effective (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353603 | Expiry (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353604 | Change Code (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353605 | Ufed Filing Status (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353606 | Ufed Num Exemptions (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353607 | Ufed Ann Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353608 | Ufed Add Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353609 | Ufed Add Tax Per Prd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353610 | Ufed Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353611 | Ufed Tax Percent (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353612 | Ufed Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353613 | Ufed Suppl Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353614 | Ufed Fica Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353615 | Ufed Medicare Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353616 | Ufed Futa Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353617 | Ufed Eic Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353618 | Ust Reciprocation (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353619 | Ust Filing Status (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353620 | Ust Num Exemption 1 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353621 | Ust Num Exemption 2 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353622 | Ust Ann Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353623 | Ust Add Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353624 | Ust Add Tax Per Prd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353625 | Ust Add Tax Res (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353626 | Ust Add Tax Work (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353627 | Ust Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353628 | Ust Tax Percent (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353629 | Ust Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353630 | Ust Suppl Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353631 | Ust Alt Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353632 | Ust Sui Ee Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353633 | Ust Sui Er Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353634 | Ust Sdi Ee Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353635 | Ust Sdi Er Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353636 | Ust WC Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353637 | Uloc Reciprocation (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353638 | Uloc Filing Status (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353639 | Uloc Num Exemptions (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353640 | Uloc Ann Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353641 | Uloc Exempt Percent (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353642 | Uloc Add Tax Per Prd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353643 | Uloc Add Tax Work (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353644 | Uloc Add Tax Res (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353645 | Uloc Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353646 | Uloc Tax Percent 1 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353647 | Uloc Tax Percent 2 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353648 | Uloc County Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353649 | Uloc City Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353650 | Uloc School Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353651 | Uloc School Tax Amt (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353652 | Uloc School Tax % (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353653 | Uloc Head Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353654 | Uloc Head Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353655 | Ust Eic Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353701 | Effective (PPRC) | if the Entity Detail (DED) legislation is for Canada, [P2K_PR_CDN_PAY_RULES] (PPRC) is retrieved for the employee's Employment effective as of the As of Date parameter|
| 353702 | Expiry (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353703 | Change Code (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353704 | Cfed Td1 Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353705 | Cfed Ann Tax Credit (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353706 | Cfed Ann Tax Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353707 | Cfed Ann Area Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353708 | Cfed Tax Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353709 | Cfed Tax Percent (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353710 | Cfed Add Tax Per Prd (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353711 | Cfed Filing Status (PPRC) | From[ P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353712 | Cfed Tax Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353713 | Cfed Cpp Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353714 | Cfed Ei Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353715 | Cfed Labour Fund (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353716 | Cprv Claim Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353717 | Cprv Num Dependents (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353718 | Cprv Ann Tax Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353719 | Cprv Tax Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353720 | Cprv Tax Percent (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353721 | Cprv Add Tax Per Prd (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353722 | Cprv Filing Status (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353723 | Cprv Tax Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353724 | Cprv Qpp Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353725 | Cprv Health Tax Mthd (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353726 | Cprv WC Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353727 | Fed Tax Claim Type (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353728 | Fed Tax Claim Code (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353729 | Prov Tax Claim Type (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353730 | Prov Tax Claim Code (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353731 | Cprv Ann Tax Credit (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353732 | Cprv Ann Area Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353801 | Contacts ect_id (ECT) |From [P2K_HR_CONTACTS] (ECT) |If the Interface Level parameter = '02 - EEM + EASD + Contacts', [P2K_HR_CONTACTS] (ECT) is retrieved for the employee's Identity (EID). If the Interface Level parameter = '04 - BE Plans + Contacts', [P2K_HR_CONTACTS] (ECT) is retrieved for the employee's Benefit Recipients (BBR) of the Benefit Enrollment (BEN) of the Employments (EEM)
| 353802 | First_name (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353803 | Middle_name (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353804 | Last_name (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353805 | Last, First, Middle (ECT) | From [P2K_HR_CONTACTS] (ECT)|The contact's name is returned as follows: Last name + ',' + First name + space + Middle name e.g. Smith, Mary Beverley
| 353806 | Last, First, Initial (ECT) |From [P2K_HR_CONTACTS] (ECT) |The contact's name is returned as follows: Last name + ',' + First name + space + Middle Initial e.g. Smith, Mary B
| 353807 | First, Middle, Last (ECT) | From [P2K_HR_CONTACTS] (ECT)|The contact's name is returned as follows: First name + space + Middle name + space + Last name e.g. Mary Beverley Smith
| 353808 | Gender (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353809 | Relation (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353810 | S.S.N. (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353811 | Birth_date (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353812 | Language_code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353813 | Salutation (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353814 | Rank (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353815 | Employer (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353816 | Contact_title (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353817 | Address_line_1 (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353818 | Address_line_2 (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353819 | Addr Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address Line 2 and Locality (city) are concatenated
| 353820 | City (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353821 | State Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353822 | Country Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353823 | Zip Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353824 | State+Cntry+Zip (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address State/Prov, Country and Postal Code are concatenated
| 353825 | Mail_address_line_1 (ECT) |From [P2K_HR_CONTACTS] (ECT) |if Mailing address does not exist, the primary address will be used
| 353826 | Mail_address_line_2 (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353827 | Mail Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Mailing Address Line 2 and Locality (city) are concatenated
| 353828 | Mail City (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353829 | Mail State (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353830 | Mail Country Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353831 | Mail Zip Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353832 | Mail State+Cntry+Zip (ECT) | From [P2K_HR_CONTACTS] (ECT)|contact’s Mailing Address State/Prov, Country and Postal Code are concatenated
| 353833 | Phone_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353834 | Phone_extension (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353835 | Alt_phone_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353836 | Alt_phone_extn (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353837 | Cellular_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353838 | Fax_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353839 | Email_address (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353840 | Security_level (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353841 | Private_item (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353842 | Web_address (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353843 | Govt_code_origin (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353844 | Contacts eid_id (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353845 | Contacts mus_id (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353846 | Student_Indicator (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353847 | Student_Until (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353848 | Disabled (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 355001 | Enrollment id (BEN) |[P2K_BE_ENROLLMENTS] (BEN) |If the Interface Level parameter = '03 - BE Plans' or '04 - BE Plans + Contacts', [P2K_BE_ENROLLMENTS] (BEN)is retrieved for the user specified Benefit Plan codes and Benefit Plan types of the report's parameter. Tthis field returns the [BEN_ID], you may use this id in derivation expression to return other value that is related to [BEN_ID]
| 355002 | Enroll Detail id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for BEN effective as of the As of Date parameter|This field returns the [BEND_ID], you may use this id in derivation expression to return other value that is related to [BEND_ID]
| 355003 | Effective (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355004 | Expiry (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355005 | Unofficial (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355006 | Enrollment_status (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355007 | Participation_rule (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355008 | Coverage_step_code (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355009 | Description (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355010 | Elig_start_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355011 | Elig_end_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355012 | Prem_start_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355013 | Prem_end_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355014 | Plan_reg_number (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355015 | Evidence_of_ins (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355016 | Percentage (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355020 | Freq pfq_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355021 | Change reason dcr_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355022 | Covg bcg_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355023 | Orig bend_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355101 | Plan Type id (BPT) | From [P2K_BE_ENROLLMENTS] (BEN), it links to the [P2K_BE_PLAN_DEFINITIONS] (BPN) which links to [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)| This field returns the [BPT_ID], you may use this id in derivation expression to return other value that is related to [BPT_ID]
| 355102 | Plan_type_code (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)|
| 355103 | Description (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)|
| 355104 | Calc_sequence (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)|
| 355201 | Plan Defn id (BPN) | From [P2K_BE_ENROLLMENTS] (BEN), it links to the [P2K_BE_PLAN_DEFINITIONS] (BPN)|This field returns the [BPN_ID], you may use this id in derivation expression to return other value that is related to [BPN_ID]
| 355202 | Plan_code (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355203 | Description (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355204 | Plan_access_code (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355205 | Established_date (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355206 | Participation_rule (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355207 | Policy_number (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355208 | Calc_sequence (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355209 | Plan_remit_seq (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355210 | Track_decline (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355211 | Last_remit_date (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355212 | Remit_by_state (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355213 | Remit_by_un_grp (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355214 | Remit_date_rule (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355215 | Remit_asof_day (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355216 | Print_zero_rule (BPN) | From [P2K_BE_PLAN_DEFINITIONS](BPN)|
| 355217 | Print_all_waivers (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355218 | Not_scheduled (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355219 | Plan_end_date (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355220 | Approval_required (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355221 | Plan den_id (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355222 | Plan dcl_id (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355223 | Plan brm_id (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355301 | Coverage id (BCG) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for this employee for this benefit plan, it links to the [P2K_BE_COVERAGES] (BCG) to indicate the coverage the employee has elected for the BE plan|This field returns the [BCG_ID], you may use this id in derivation expression to return other value that is related to [BCG_ID]
| 355302 | Coverage_code (BCG) |From [P2K_BE_COVERAGES] (BCG) |
| 355303 | Covg_remit_seq (BCG) |From [P2K_BE_COVERAGES] (BCG) |
| 355304 | Policy_number (BCG) | From [P2K_BE_COVERAGES] (BCG)|
| 355305 | Contact_role (BCG) | From [P2K_BE_COVERAGES] (BCG)|
| 355306 | Covg muc_id (BCG) | From [P2K_BE_COVERAGES] (BCG)|
| 355401 | Covg Detail id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD) effective as of the As of Date parameter|
| 355402 | Effective (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355403 | Expiry (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355404 | Remit_basis (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355405 | Rate_basis (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355406 | Description (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355407 | Covg Detail pfq_id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355408 | Covg Detail dcr_id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355501 | Covg Rate id (BCGR) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for this employee for this benefit plan, it specifies the [COVERAGE_STEP_CODE] to indicate the coverage step the employee has elected for the BE plan. [P2K_BE_COVERAGE_RATES] (BCGR) is retrieved for the BEND Benefit Coverage Detail and [COVERAGE_STEP_CODE]|This field returns the [BCGR_ID], you may use this id in derivation expression to return other value that is related to [BCGR_ID]
| 355502 | Covg_step_code (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355503 | Description (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355504 | Up_to_limit (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355505 | Next_step_code (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355506 | Flex_amount (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355507 | Premium1_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355508 | Premium2_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355509 | EE_deduct_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355510 | ER_contrib_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355511 | Taxben_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355512 | User1_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355513 | User2_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355514 | User3_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355601 | Ben Recip id (BBR) |From [P2K_BE_BENEFIT_RECIPIENTS] (BBR) |If the Interface Level parameter = '04 - BE Plans + Contacts', the function (ie [UEEF]) will retrieve the Benefit Recipients [P2K_BE_BENEFIT_RECIPIENTS] (BBR) for the Benefit Enrollment (BEN) in order to retrieve the Benefit Contacts (ECT) information that links to Benefit Recipients. This field returns the [BBR_ID], you may use this id in derivation expression to return other value that is related to [BBR_ID]
| 355602 | Start_date (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
| 355603 | End_date (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
| 355604 | Benefit_percent (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
| 355605 | Bond_participation (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
At line 527 changed 19 lines
| 358001 | Internal Table Desc1 | |
| 358002 | Internal Table Desc2 | |
| 358003 | Internal Table Desc3 | |
| 358004 | Internal Table Desc4 | |
| 358005 | Internal Table Desc5 | |
| 358011 | Internal Table Amt 1 | |
| 358012 | Internal Table Amt 2 | |
| 358013 | Internal Table Amt 3 | |
| 358014 | Internal Table Amt 4 | |
| 358015 | Internal Table Amt 5 | |
| 358021 | Internal Total for Amt 1 | |
| 358022 | Internal Total for Amt 2 | |
| 358023 | Internal Total for Amt 3 | |
| 358024 | Internal Total for Amt 4 | |
| 358025 | Internal Total for Amt 5 | |
| 358030 | UDF (EID) (35) | |
| 358031 | UDF (EEM) (35) | |
| 358032 | UDF (EASD) (35) | |
| 358033 | UDF (BPN) (35) | |
| 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
At line 552 changed 3 lines
| 358040 | Element (PPH) | |
| 358041 | Internal Element | |
| 358042 | Statistic Amt (IEST) (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
At line 558 changed 12 lines
| 358051 | Internal Element+UDF(EEM) | |
| 358061 | UDF(EEM)+Internal Element | |
| 359000 | Record Count (35) | |
| 359001 | Total Record Count (35) | |
| 359002 | Total Employer Count (35) | |
| 359003 | Total Value (35) | |
| 359004 | Detail Record Count (35) | |
| 359005 | Detail Level 1 Count | |
| 359006 | Detail Level 2 Count | |
| 359007 | Detail Level 3 Count | |
| 359008 | Detail Level 4 Count | |
| 359009 | Detail Level 5 Count | |
| 358051 | Internal Element+UDF(EEM) |Indicates this Rec#/Fld# contains an internal Element value that is loaded in program |Value that is loaded in program. On [IDIF] screen, you should enter the Element name in the Constant Value field to be used for both the UDF (EEM) and the Internal Element. This is not supported in [UBEF] because Element value is not loaded for Employee Interface but this is supported in [UPROEF].
| 358061 | UDF(EEM)+Internal Element | Same as 358051 above. 358051 field returns the Element value, 358061 field returns the UDF(EEM) value| This is not supported in [UBEF] because Element value is not loaded for Employee Interface.
| 359000 | Record Count (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|
| 359005 | Detail Level 1 Count | Contains Record Count for Record Type = 'Detail Level 1', available for Header and Trailer records|
| 359006 | Detail Level 2 Count | Contains Record Count for Record Type = 'Detail Level 2', available for Header and Trailer records|
| 359007 | Detail Level 3 Count | Contains Record Count for Record Type = 'Detail Level 3', available for Header and Trailer records|
| 359008 | Detail Level 4 Count | Contains Record Count for Record Type = 'Detail Level 4', available for Header and Trailer records|
| 359009 | Detail Level 5 Count | Contains Record Count for Record Type = 'Detail Level 5', available for Header and Trailer records|
At line 573 added 4 lines
----
![Notes|Edit:Internal.X_INF_VARIABLE_NAME (35)]
[{InsertPage page='Internal.X_INF_VARIABLE_NAME (35)' default='Click to create a new notes page'}]
This page (revision-27) was last changed on 26-Nov-2021 10:22 by kparrottTop