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 7 lines
| 350001 | XML Begin Tag (35) | |
| 350002 | XML End Tag (35) | |
| 350003 | Constant Value (35) | |
| 350004 | System Date/Time (35) | |
| 350005 | As Of Date (35) | |
| 350006 | Execution ID (35) | |
| 350007 | User Calc (35) | |
| 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
| 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 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
At line 15 changed 3 lines
| 350020 | First Pay Beg Dt of Yr | |
| 350021 | Last Pay End Dt of Yr | |
| 350022 | First BEND effdt | |
| 350020 | First Pay Beg Dt of Yr | Contains the very first pay period start date in a calendar year|
| 350021 | Last Pay End Dt of Yr | Contains the very last pay period end date in a calendar year.|
| 350022 | First BEND effdt | Contains the first enrollment details effective date within the selected period when multiple details are required to be combined (applicable to the ACTIVE and LTD coverage codes only).|
At line 22 changed 99 lines
| 350100 | Entity den_id (DEN) | |
| 350101 | Entity Code (DEN) | |
| 350102 | Standing (DEN) | |
| 350103 | G/L Company (DEN) (35) | |
| 350110 | Effective (DED) | |
| 350111 | Expiry (DED) | |
| 350112 | Entity Name (DED) | |
| 350113 | Legislation (DED) | |
| 350114 | Language Code (DED) | |
| 350115 | Currency (DED) | |
| 350116 | DUNS Number (DED) | |
| 350117 | WEB Address (DED) | |
| 350201 | Location Code (DLN) | |
| 350202 | Location Desc (DLN) | |
| 350203 | Font HTML (DLN) | |
| 350204 | Language Code (DLN) | |
| 350205 | Address 1 (DLN) | |
| 350206 | Address 2 (DLN) | |
| 350207 | Address 2 + City (DLN) | |
| 350212 | City (DLN) | |
| 350213 | State Code (DLN) | |
| 350214 | Country Code (DLN) | |
| 350215 | Zip (DLN) | |
| 350216 | State+Cntry+Zip (DLN) | |
| 350220 | Mail Address 1 (DLN) | |
| 350221 | Mail Address 2 (DLN) | |
| 350222 | Mail Adr 2 + City (DLN) | |
| 350223 | Mail City (DLN) | |
| 350224 | Mail State (DLN) | |
| 350225 | Mail Country Code (DLN) | |
| 350226 | Mail Zip (DLN) | |
| 350227 | Mail State+Cntry+Zip(DLN) | |
| 350237 | Phone Number (DLN) | |
| 350238 | Phone Number Ext (DLN) | |
| 350239 | Alt Phone Number (DLN) | |
| 350240 | Alt Phone Number Ext (DLN) | |
| 350241 | Fax Number (DLN) | |
| 350242 | Email Address (DLN) | |
| 350243 | Bilingual Region (DLN) | |
| 350244 | Bilingual Location (DLN) | |
| 350245 | CMA Code (DLN) | |
| 350300 | Department ddp_id (DDP) | |
| 350301 | Department Code (DDP) | |
| 350302 | Standing (DDP) | |
| 350303 | Generic Code (DDP) | |
| 350310 | Effective (DDD) | |
| 350311 | Expiry (DDD) | |
| 350312 | Department Name (DDD) | |
| 350313 | Distribution Mask (DDD) | |
| 350314 | Burden Percent (DDD) | |
| 350315 | Phone Number (DDD) | |
| 350316 | Phone Number Ext (DDD) | |
| 350317 | Fax Number (DDD) | |
| 350318 | Email Address (DDD) | |
| 350319 | EEOC Function (DDD) | |
| 350320 | Batch Code (DDD) | |
| 350321 | Office Code (DDD) | |
| 350322 | Burden Method (DDD) | |
| 350400 | Unit dun_id (DUN) | |
| 350401 | Unit Code (DUN) | |
| 350402 | Standing (DUN) | |
| 350410 | Effective (DUD) | |
| 350411 | Expiry (DUD) | |
| 350412 | Unit Status (DUD) | |
| 350413 | Unit Description (DUD) | |
| 350414 | Agreement Start Date (DUD) | |
| 350415 | Agreement End Date (DUD) | |
| 350416 | Unit Name (DUD) | |
| 350417 | Unit Local (DUD) | |
| 350418 | Unit Sub Local (DUD) | |
| 350419 | Unit Text (DUD) | |
| 350500 | Group dgr_id (DGR) | |
| 350501 | Group Code (DGR) | |
| 350502 | Standing (DGR) | |
| 350510 | Effective (DGD) | |
| 350511 | Expiry (DGD) | |
| 350512 | Group Description (DGD) | |
| 350513 | Group Type (DGD) | |
| 350514 | Pay Type (DGD) | |
| 350515 | Contract Type (DGD) | |
| 350516 | Employment Type (DGD) | |
| 350517 | Std Hours Per Day (DGD) | |
| 350518 | Std Hours Per Week (DGD) | |
| 350519 | Std Hours Per Pay (DGD) | |
| 350520 | Weeks Per Year (DGD) | |
| 350521 | Months Per Year (DGD) | |
| 350522 | Hourly Rounding (DGD) | |
| 350523 | Daily Rounding (DGD) | |
| 350524 | Use FTE Wages (DGD) | |
| 350525 | Accrual Method (DGD) | |
| 350526 | CDN EI Reduced Rate (DGD) | |
| 350527 | Pay By Check (DGD) | |
| 350528 | FLSA Factor (DGD) | |
| 350529 | FLSA Hours (DGD) | |
| 350530 | W2 Employment Type (DGD) | |
| 350601 | Payroll Code (PPA) | |
| 350602 | Legislation (PPA) | |
| 350603 | Description (PPA) | |
| 350701 | Pay Calendar Code (PCL) | |
| 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
This page (revision-27) was last changed on 26-Nov-2021 10:22 by kparrottTop