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 8 changed one line
| 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
| 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
At line 11 changed 2 lines
| 350005 | As Of Date (35) | From UBEF As Of Date parameter|
| 350006 | Execution ID (35) | From UBEF Execution ID of the run|
| 350005 | As Of Date (35) | From [UBEF] As Of Date parameter|
| 350006 | Execution ID (35) | From [UBEF] Execution ID of the run|
At line 22 changed 129 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|
| 350111 | Expiry (DED) | From P2K_CM_ENTITY_DETAILS (DED)|
| 350112 | Entity Name (DED) |From P2K_CM_ENTITY_DETAILS (DED) |
| 350113 | Legislation (DED) |From P2K_CM_ENTITY_DETAILS (DED) |
| 350114 | Language Code (DED) | From P2K_CM_ENTITY_DETAILS (DED)|
| 350115 | Currency (DED) |From P2K_CM_ENTITY_DETAILS (DED) |
| 350116 | DUNS Number (DED) | From P2K_CM_ENTITY_DETAILS (DED)|
| 350117 | WEB Address (DED) | From P2K_CM_ENTITY_DETAILS (DED)|
| 350201 | Location Code (DLN) | P2K_CM_LOCATIONS (DLN) is retrieved from DED.DLN_ID|If UEEF parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
| 350202 | Location Desc (DLN) |From P2K_CM_LOCATIONS (DLN) |
| 350203 | Font HTML (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350204 | Language Code (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350205 | Address 1 (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350206 | Address 2 (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350207 | Address 2 + City (DLN) |From P2K_CM_LOCATIONS (DLN) |Location Address Line 2 and Locality (city) are concatenated
| 350212 | City (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350213 | State Code (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350214 | Country Code (DLN) |From P2K_CM_LOCATIONS (DLN) |
| 350215 | Zip (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350216 | State+Cntry+Zip (DLN) |From P2K_CM_LOCATIONS (DLN) |Location State/Prov, Country and Postal Code are concatenated
| 350220 | Mail Address 1 (DLN) | From P2K_CM_LOCATIONS (DLN)|If Mailing address does not exist, the primary address will be used
| 350221 | Mail Address 2 (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350222 | Mail Adr 2 + City (DLN) | From P2K_CM_LOCATIONS (DLN)|Location Mailing Address Line 2 and Locality (city) are concatenated
| 350223 | Mail City (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350224 | Mail State (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350225 | Mail Country Code (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350226 | Mail Zip (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350227 | Mail State+Cntry+Zip(DLN) | From P2K_CM_LOCATIONS (DLN)|Location Mailing Address State/Prov, Country and Postal Code are concatenated
| 350237 | Phone Number (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350238 | Phone Number Ext (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350239 | Alt Phone Number (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350240 | Alt Phone Number Ext (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350241 | Fax Number (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350242 | Email Address (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350243 | Bilingual Region (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350244 | Bilingual Location (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350245 | CMA Code (DLN) | From P2K_CM_LOCATIONS (DLN)|
| 350300 | Department ddp_id (DDP) | P2K_CM_DEPARTMENTS (DDP) is retrieved from employee's prime assignment|This field returns the ddp.id, user may use this id in derivation expression to return other value that is related to ddp.id
| 350301 | Department Code (DDP) | From P2K_CM_DEPARTMENTS (DDP)|
| 350302 | Standing (DDP) | From P2K_CM_DEPARTMENTS (DDP)|
| 350303 | Generic Code (DDP) | From P2K_CM_DEPARTMENTS (DDP)|
| 350310 | Effective (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD) effective as of UEEF As of Date parameter|
| 350311 | Expiry (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350312 | Department Name (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350313 | Distribution Mask (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350314 | Burden Percent (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350315 | Phone Number (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350316 | Phone Number Ext (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350317 | Fax Number (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350318 | Email Address (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350319 | EEOC Function (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350320 | Batch Code (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350321 | Office Code (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350322 | Burden Method (DDD) | From P2K_CM_DEPARTMENT_DETAILS (DDD)|
| 350400 | Unit dun_id (DUN) | P2K_CM_UNITS (DUN) is retrieved from employee's prime assignment|This field returns the dun.id, you may use this id in derivation expression to return other value that is related to dun.id
| 350401 | Unit Code (DUN) | From P2K_CM_UNITS (DUN)|
| 350402 | Standing (DUN) | From P2K_CM_UNITS (DUN)|
| 350410 | Effective (DUD) | From P2K_CM_UNIT_DETAILS (DUD) effective as of UEEF As of Date parameter|
| 350411 | Expiry (DUD) | From P2K_CM_UNIT_DETAILS (DUD)|
| 350412 | Unit Status (DUD) |From P2K_CM_UNIT_DETAILS (DUD) |
| 350413 | Unit Description (DUD) | From P2K_CM_UNIT_DETAILS (DUD)|
| 350414 | Agreement Start Date (DUD) | From P2K_CM_UNIT_DETAILS (DUD)|
| 350415 | Agreement End Date (DUD) | From P2K_CM_UNIT_DETAILS (DUD)|
| 350416 | Unit Name (DUD) | From P2K_CM_UNIT_DETAILS (DUD)|
| 350417 | Unit Local (DUD) | From P2K_CM_UNIT_DETAILS (DUD)|
| 350418 | Unit Sub Local (DUD) | From P2K_CM_UNIT_DETAILS (DUD)|
| 350419 | Unit Text (DUD) | From P2K_CM_UNIT_DETAILS (DUD)|
| 350500 | Group dgr_id (DGR) | P2K_CM_GROUPS (DGR) is retrieved from the employee's prime assignment dgr_id| This field returns the dgr.id, you may use this id in derivation expression to return other value that is related to dgr.id
| 350501 | Group Code (DGR) | From P2K_CM_GROUPS (DGR)|
| 350502 | Standing (DGR) | From P2K_CM_GROUPS (DGR)|
| 350510 | Effective (DGD) | From P2K_CM_GROUP_DETAILS (DGD) effective as of UEEF As of Date parameter|
| 350511 | Expiry (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350512 | Group Description (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350513 | Group Type (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350514 | Pay Type (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350515 | Contract Type (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350516 | Employment Type (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350517 | Std Hours Per Day (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350518 | Std Hours Per Week (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350519 | Std Hours Per Pay (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350520 | Weeks Per Year (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350521 | Months Per Year (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350522 | Hourly Rounding (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350523 | Daily Rounding (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350524 | Use FTE Wages (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350525 | Accrual Method (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350526 | CDN EI Reduced Rate (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350527 | Pay By Check (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350528 | FLSA Factor (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350529 | FLSA Hours (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350530 | W2 Employment Type (DGD) | From P2K_CM_GROUP_DETAILS (DGD)|
| 350601 | Payroll Code (PPA) | P2K_PR_PAYROLLS (PPA) is retrieved from the employee's prime assignment group details|This field returns the Payroll code from PPA
| 350602 | Legislation (PPA) | From P2K_PR_PAYROLLS (PPA)|
| 350603 | Description (PPA) |From P2K_PR_PAYROLLS (PPA) |
| 350701 | Pay Calendar Code (PCL) | P2K_PR_PAY_CALENDARS (PCL) is retrieved from the employee's prime assignment group details Payroll code|This field returns the Pay Calendar code from PCL
| 350702 | Pay Frequency (PCL) |From P2K_PR_PAY_CALENDARS (PCL) |
| 350703 | Weeks Per Pay (PCL) | From P2K_PR_PAY_CALENDARS (PCL)|
| 350704 | Pay Calendar Desc (PCL) | From P2K_PR_PAY_CALENDARS (PCL)|
| 350800 | Govt Regist Number (DGV) |P2K_CM_GOVT_REGISTRATIONS (DGV) is retrieved from the employee's prime assignment group details Federal Registration |This field returns the Govt Regist Number from DGV
| 350801 | Govt Regist dgv_id (35) |From P2K_CM_GOVT_REGISTRATIONS (DGV) |
| 350802 | Govt Regist Type (DGV) | From P2K_CM_GOVT_REGISTRATIONS (DGV)|
| 350803 | Govt Regist Desc (DGV) | From P2K_CM_GOVT_REGISTRATIONS (DGV)|
| 353100 | Person Code (EID) | P2K_HR_IDENTITIES (EID) is retrieved for the employee|This field returns the Person code 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',~)''
| 353102 | S.S.N. (EID) | From P2K_HR_IDENTITIES (EID)|
| 353103 | First Name (EID) |From P2K_HR_IDENTITIES (EID) |
| 353104 | Middle Name (EID) | From P2K_HR_IDENTITIES (EID)|
| 353105 | Last Name (EID) | From P2K_HR_IDENTITIES (EID)|
| 353106 | Last, First, Middle (EID) |From P2K_HR_IDENTITIES (EID) |The employee's name is returned as follows: ''Last name + ',' + First name + space + Middle name e.g. Smith, Mary Beverley''
| 353107 | Last, First, Initial (EID) |From P2K_HR_IDENTITIES (EID)| The employee's name is returned as follows: ''Last name + ',' + First name + space + Middle Initial e.g. Smith, Mary B''
| 353108 | First, Middle, Last (EID) | From P2K_HR_IDENTITIES (EID)|The employee's name is returned as follows: ''First name + space + Middle name + space + Last name e.g. Mary Beverley Smith''
| 353109 | First, Initial, Last (EID) |From P2K_HR_IDENTITIES (EID) |The employee's name is returned as follows: ''First name + space + Middle Initial + space + Last name e.g. Mary B Smith''
| 353126 | Birth Date (EID) |From P2K_HR_IDENTITIES (EID) |
| 353127 | Gender (EID) | From P2K_HR_IDENTITIES (EID)|
| 353128 | Language Code (EID) | From P2K_HR_IDENTITIES (EID)|
| 353129 | Ethnic (EID) | From P2K_HR_IDENTITIES (EID)|
| 353130 | Salutation (EID) | From P2K_HR_IDENTITIES (EID)|
| 353131 | Rank (EID) | From P2K_HR_IDENTITIES (EID)|
| 353132 | Birth Place (EID) | From P2K_HR_IDENTITIES (EID)|
| 353133 | Challenged (EID) | From P2K_HR_IDENTITIES (EID)|
| 353134 | Vetern Status (EID) | From P2K_HR_IDENTITIES (EID)|
| 353135 | Photo Location (EID) | From P2K_HR_IDENTITIES (EID)|
| 353136 | Drivers License (EID) | From P2K_HR_IDENTITIES (EID)|
| 353137 | Alt Language Code (EID) | From P2K_HR_IDENTITIES (EID)|
| 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|
| 350111 | Expiry (DED) | From [P2K_CM_ENTITY_DETAILS] (DED)|
| 350112 | Entity Name (DED) |From [P2K_CM_ENTITY_DETAILS] (DED) |
| 350113 | Legislation (DED) |From [P2K_CM_ENTITY_DETAILS] (DED) |
| 350114 | Language Code (DED) | From [P2K_CM_ENTITY_DETAILS] (DED)|
| 350115 | Currency (DED) |From [P2K_CM_ENTITY_DETAILS] (DED) |
| 350116 | DUNS Number (DED) | From [P2K_CM_ENTITY_DETAILS] (DED)|
| 350117 | WEB Address (DED) | From [P2K_CM_ENTITY_DETAILS] (DED)|
| 350201 | Location Code (DLN) | [P2K_CM_LOCATIONS] (DLN) is retrieved from DED.DLN_ID|If [UEEF] parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
| 350202 | Location Desc (DLN) |From [P2K_CM_LOCATIONS] (DLN) |
| 350203 | Font HTML (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350204 | Language Code (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350205 | Address 1 (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350206 | Address 2 (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350207 | Address 2 + City (DLN) |From [P2K_CM_LOCATIONS] (DLN) |Location Address Line 2 and Locality (city) are concatenated
| 350212 | City (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350213 | State Code (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350214 | Country Code (DLN) |From [P2K_CM_LOCATIONS] (DLN) |
| 350215 | Zip (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350216 | State+Cntry+Zip (DLN) |From [P2K_CM_LOCATIONS] (DLN) |Location State/Prov, Country and Postal Code are concatenated
| 350220 | Mail Address 1 (DLN) | From [P2K_CM_LOCATIONS] (DLN)|If Mailing address does not exist, the primary address will be used
| 350221 | Mail Address 2 (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350222 | Mail Adr 2 + City (DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address Line 2 and Locality (city) are concatenated
| 350223 | Mail City (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350224 | Mail State (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350225 | Mail Country Code (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350226 | Mail Zip (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350227 | Mail State+Cntry+Zip(DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address State/Prov, Country and Postal Code are concatenated
| 350237 | Phone Number (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350238 | Phone Number Ext (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350239 | Alt Phone Number (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350240 | Alt Phone Number Ext (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350241 | Fax Number (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350242 | Email Address (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350243 | Bilingual Region (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350244 | Bilingual Location (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350245 | CMA Code (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350300 | Department ddp_id (DDP) | [P2K_CM_DEPARTMENTS] (DDP) is retrieved from employee's prime assignment|This field returns the ddp.id, user may use this id in derivation expression to return other value that is related to ddp.id
| 350301 | Department Code (DDP) | From [P2K_CM_DEPARTMENTS] (DDP)|
| 350302 | Standing (DDP) | From [P2K_CM_DEPARTMENTS] (DDP)|
| 350303 | Generic Code (DDP) | From [P2K_CM_DEPARTMENTS] (DDP)|
| 350310 | Effective (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD) effective as of UEEF As of Date parameter|
| 350311 | Expiry (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350312 | Department Name (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350313 | Distribution Mask (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350314 | Burden Percent (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350315 | Phone Number (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350316 | Phone Number Ext (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350317 | Fax Number (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350318 | Email Address (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350319 | EEOC Function (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350320 | Batch Code (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350321 | Office Code (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350322 | Burden Method (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD)|
| 350400 | Unit dun_id (DUN) |[P2K_CM_UNITS] (DUN) is retrieved from employee's prime assignment|This field returns the dun.id, you may use this id in derivation expression to return other value that is related to dun.id
| 350401 | Unit Code (DUN) | From [P2K_CM_UNITS] (DUN)|
| 350402 | Standing (DUN) | From [P2K_CM_UNITS] (DUN)|
| 350410 | Effective (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD) effective as of [UEEF] As of Date parameter|
| 350411 | Expiry (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350412 | Unit Status (DUD) |From [P2K_CM_UNIT_DETAILS] (DUD) |
| 350413 | Unit Description (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350414 | Agreement Start Date (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350415 | Agreement End Date (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350416 | Unit Name (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350417 | Unit Local (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350418 | Unit Sub Local (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350419 | Unit Text (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD)|
| 350500 | Group dgr_id (DGR) | [P2K_CM_GROUPS] (DGR) is retrieved from the employee's prime assignment dgr_id| This field returns the dgr.id, you may use this id in derivation expression to return other value that is related to dgr.id
| 350501 | Group Code (DGR) | From [P2K_CM_GROUPS] (DGR)|
| 350502 | Standing (DGR) | From [P2K_CM_GROUPS] (DGR)|
| 350510 | Effective (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD) effective as of the As of Date parameter|
| 350511 | Expiry (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350512 | Group Description (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350513 | Group Type (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350514 | Pay Type (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350515 | Contract Type (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350516 | Employment Type (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350517 | Std Hours Per Day (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350518 | Std Hours Per Week (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350519 | Std Hours Per Pay (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350520 | Weeks Per Year (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350521 | Months Per Year (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350522 | Hourly Rounding (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350523 | Daily Rounding (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350524 | Use FTE Wages (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350525 | Accrual Method (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350526 | CDN EI Reduced Rate (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350527 | Pay By Check (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350528 | FLSA Factor (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350529 | FLSA Hours (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350530 | W2 Employment Type (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD)|
| 350601 | Payroll Code (PPA) | [P2K_PR_PAYROLLS] (PPA) is retrieved from the employee's prime assignment group details|This field returns the Payroll code from PPA
| 350602 | Legislation (PPA) | From [P2K_PR_PAYROLLS] (PPA)|
| 350603 | Description (PPA) |From [P2K_PR_PAYROLLS] (PPA) |
| 350701 | Pay Calendar Code (PCL) | [P2K_PR_PAY_CALENDARS] (PCL) is retrieved from the employee's prime assignment group details Payroll code|This field returns the Pay Calendar code from PCL
| 350702 | Pay Frequency (PCL) |From [P2K_PR_PAY_CALENDARS] (PCL) |
| 350703 | Weeks Per Pay (PCL) | From [P2K_PR_PAY_CALENDARS] (PCL)|
| 350704 | Pay Calendar Desc (PCL) | From [P2K_PR_PAY_CALENDARS] (PCL)|
| 350800 | Govt Regist Number (DGV) |[P2K_CM_GOVT_REGISTRATIONS] (DGV) is retrieved from the employee's prime assignment group details Federal Registration |This field returns the Govt Regist Number from DGV
| 350801 | Govt Regist dgv_id (35) |From [P2K_CM_GOVT_REGISTRATIONS] (DGV) |
| 350802 | Govt Regist Type (DGV) | From [P2K_CM_GOVT_REGISTRATIONS] (DGV)|
| 350803 | Govt Regist Desc (DGV) | From [P2K_CM_GOVT_REGISTRATIONS] (DGV)|
| 353100 | Person Code (EID) | [P2K_HR_IDENTITIES] (EID) is retrieved for the employee|This field returns the Person code 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',~)''
| 353102 | S.S.N. (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353103 | First Name (EID) |From [P2K_HR_IDENTITIES] (EID) |
| 353104 | Middle Name (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353105 | Last Name (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353106 | Last, First, Middle (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: ''Last name + ',' + First name + space + Middle name e.g. Smith, Mary Beverley''
| 353107 | Last, First, Initial (EID) |From [P2K_HR_IDENTITIES] (EID)| The employee's name is returned as follows: ''Last name + ',' + First name + space + Middle Initial e.g. Smith, Mary B''
| 353108 | First, Middle, Last (EID) | From [P2K_HR_IDENTITIES] (EID)|The employee's name is returned as follows: ''First name + space + Middle name + space + Last name e.g. Mary Beverley Smith''
| 353109 | First, Initial, Last (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: ''First name + space + Middle Initial + space + Last name e.g. Mary B Smith''
| 353126 | Birth Date (EID) |From [P2K_HR_IDENTITIES] (EID) |
| 353127 | Gender (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353128 | Language Code (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353129 | Ethnic (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353130 | Salutation (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353131 | Rank (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353132 | Birth Place (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353133 | Challenged (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353134 | Vetern Status (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353135 | Photo Location (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353136 | Drivers License (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353137 | Alt Language Code (EID) | From [P2K_HR_IDENTITIES] (EID)|
This page (revision-27) was last changed on 26-Nov-2021 10:22 by kparrottTop