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 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 \\ 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
At line 13 changed one line
| 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
| 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 one line
| 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',~)|
| 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',~)
At line 151 changed 90 lines
| 353138 | Govt Code Origin (EID) | From P2K_HR_IDENTITIES (EID)|
| 353139 | User Code (EID) | From P2K_HR_IDENTITIES (EID)|
| 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
| 353201 | Effective (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353202 | Expiry (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353203 | Change Code (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353204 | Address 1 (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353205 | Address 2 (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353206 | Address 2 + City (EPS) | From P2K_HR_PERSONALS (EPS)|Employee Address Line 2 and Locality (city) are concatenated
| 353207 | City (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353210 | State Code (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353211 | Country Code (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353212 | Zip (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353213 | State+Cntry+Zip (EPS) | From P2K_HR_PERSONALS (EPS)|Employee Address State/Prov, Country and Postal Code are concatenated
| 353214 | School District Code (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353215 | Tax Jurisdiction (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353220 | Mail Address 1 (EPS) | From P2K_HR_PERSONALS (EPS)|if Mailing address does not exist, the primary address will be used
| 353221 | Mail Address 2 (EPS) | From P2K_HR_PERSONALS (EPS) |
| 353222 | Mail Adr 2 + City (EPS) | From P2K_HR_PERSONALS (EPS)|Employee Mailing Address Line 2 and Locality (city) are concatenated
| 353223 | Mail City (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353224 | Mail State Prov (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353225 | Mail Country Code (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353226 | Mail Zip (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353227 | Mail State+Cntry+Zip (EPS) | From P2K_HR_PERSONALS (EPS)|Employee Mailing Address State/Prov, Country and Postal Code are concatenated
| 353238 | Phone Unlisted (EPS) |From P2K_HR_PERSONALS (EPS) |
| 353239 | Phone Number (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353240 | Alt Phone Number (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353241 | Cellular Number (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353242 | Fax Number (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353243 | Email Address (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353244 | Marital Status (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353245 | Married Date (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353246 | Number Dependents (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353247 | Years Education (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353248 | Transportation (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353249 | Bonded Status (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353250 | Citizen Status (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353251 | Citizenship Country (EPS) | From P2K_HR_PERSONALS (EPS)|
| 353252 | Foreign Code (EPS) | From P2K_HR_PERSONALS (EPS)|
| 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
| 353301 | Employment Type (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353302 | Hire Date (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353303 | Hire Sequence (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353304 | Original Hire Date (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353305 | Seniority Date (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353306 | First Work Date (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353307 | Last Work Date (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353308 | Termination Date (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353309 | Termination Code (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353310 | Roe Status (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353311 | Roe Issued Date (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353312 | Roe Letter (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353313 | Roe Comments (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353314 | Rehire Status (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353315 | Expected Return Date (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353316 | Income Guarantee (EEM) | From P2K_HR_EMPLOYMENTS (EEM)|
| 353380 | Term Description (DTR) | P2K_CM_TERMINATION_REASONS (DTR) is retrieved from the employee's Employment|This field returns the Termination description of DTR
| 353381 | Govt Term Code (DTR) | From P2K_CM_TERMINATION_REASONS (DTR)|
| 353382 | ROE Letter (DTR) | From P2K_CM_TERMINATION_REASONS (DTR)|
| 353383 | Employment Status (DTR) | From P2K_CM_TERMINATION_REASONS (DTR)|
| 353384 | Term Code (DTR) | From P2K_CM_TERMINATION_REASONS (DTR)|
| 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|
| 353395 | ROE process meth (ROE) |From UPROEF program internal Process method |
| 353396 | ROE Comment line 1 (ROE) |From UPROEF program internal Comment line 1 |
| 353397 | ROE Comment line 2 (ROE) | From UPROEF program internal Comment line 2|
| 353398 | ROE Comment line 3 (ROE) | From UPROEF program internal Comment line 3|
| 353399 | ROE Comment line 4 (ROE) | From UPROEF program internal Comment line 4|
| 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
| 353401 | Assignment Code (EAS) | From P2K_HR_ASSIGNMENTS (EAS)|
| 353402 | Assignment Type (EAS) | From P2K_HR_ASSIGNMENTS (EAS)|
| 353403 | Assignment Status (EAS) | From P2K_HR_ASSIGNMENTS (EAS)|
| 353404 | Assignment Start Date (EAS) | From P2K_HR_ASSIGNMENTS (EAS)|
| 353405 | Assignment End Date (EAS) | From P2K_HR_ASSIGNMENTS (EAS)|
| 353406 | Prime Assignment (EAS) | From P2K_HR_ASSIGNMENTS (EAS)|
| 353407 | Description (EAS) | From P2K_HR_ASSIGNMENTS (EAS)|
| 353408 | Next Review Date (EAS) | From P2K_HR_ASSIGNMENTS (EAS)|
| 353409 | Ts Seniority Date (EAS) | From P2K_HR_ASSIGNMENTS (EAS)|
| 353500 | Assignment easd_id (EASD) | P2K_HR_ASSIGNMENT_DETAILS (EASD) is retrieved for the employee's Primary Assignment effective as of UEEF As of Date parameter|This field returns the easd.id, you may use this id in derivation expression to return other value that is related to easd.id
| 353501 | Effective (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353502 | Expiry (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353503 | Change Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353504 | Employment Status Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353505 | Position Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353506 | Job Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353507 | Department Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353508 | Unit Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353138 | Govt Code Origin (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353139 | User Code (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 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
| 353201 | Effective (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353202 | Expiry (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353203 | Change Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353204 | Address 1 (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353205 | Address 2 (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353206 | Address 2 + City (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Address Line 2 and Locality (city) are concatenated
| 353207 | City (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353210 | State Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353211 | Country Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353212 | Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353213 | State+Cntry+Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Address State/Prov, Country and Postal Code are concatenated
| 353214 | School District Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353215 | Tax Jurisdiction (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353220 | Mail Address 1 (EPS) | From [P2K_HR_PERSONALS] (EPS)|if Mailing address does not exist, the primary address will be used
| 353221 | Mail Address 2 (EPS) | From [P2K_HR_PERSONALS] (EPS) |
| 353222 | Mail Adr 2 + City (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Mailing Address Line 2 and Locality (city) are concatenated
| 353223 | Mail City (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353224 | Mail State Prov (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353225 | Mail Country Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353226 | Mail Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353227 | Mail State+Cntry+Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Mailing Address State/Prov, Country and Postal Code are concatenated
| 353238 | Phone Unlisted (EPS) |From [P2K_HR_PERSONALS] (EPS) |
| 353239 | Phone Number (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353240 | Alt Phone Number (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353241 | Cellular Number (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353242 | Fax Number (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353243 | Email Address (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353244 | Marital Status (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353245 | Married Date (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353246 | Number Dependents (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353247 | Years Education (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353248 | Transportation (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353249 | Bonded Status (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353250 | Citizen Status (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353251 | Citizenship Country (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353252 | Foreign Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 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
| 353301 | Employment Type (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353302 | Hire Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353303 | Hire Sequence (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353304 | Original Hire Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353305 | Seniority Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353306 | First Work Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353307 | Last Work Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353308 | Termination Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353309 | Termination Code (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353310 | Roe Status (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353311 | Roe Issued Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353312 | Roe Letter (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353313 | Roe Comments (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353314 | Rehire Status (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353315 | Expected Return Date (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353316 | Income Guarantee (EEM) | From [P2K_HR_EMPLOYMENTS] (EEM)|
| 353380 | Term Description (DTR) | [P2K_CM_TERMINATION_REASONS] (DTR) is retrieved from the employee's Employment|This field returns the Termination description of DTR
| 353381 | Govt Term Code (DTR) | From [P2K_CM_TERMINATION_REASONS] (DTR)|
| 353382 | ROE Letter (DTR) | From [P2K_CM_TERMINATION_REASONS] (DTR)|
| 353383 | Employment Status (DTR) | From [P2K_CM_TERMINATION_REASONS] (DTR)|
| 353384 | Term Code (DTR) | From [P2K_CM_TERMINATION_REASONS] (DTR)|
| 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|
| 353395 | ROE process meth (ROE) |From [UPROEF] program internal Process method |
| 353396 | ROE Comment line 1 (ROE) |From [UPROEF] program internal Comment line 1 |
| 353397 | ROE Comment line 2 (ROE) | From [UPROEF] program internal Comment line 2|
| 353398 | ROE Comment line 3 (ROE) | From [UPROEF] program internal Comment line 3|
| 353399 | ROE Comment line 4 (ROE) | From [UPROEF] program internal Comment line 4|
| 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
| 353401 | Assignment Code (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353402 | Assignment Type (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353403 | Assignment Status (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353404 | Assignment Start Date (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353405 | Assignment End Date (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353406 | Prime Assignment (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353407 | Description (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353408 | Next Review Date (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 353409 | Ts Seniority Date (EAS) | From [P2K_HR_ASSIGNMENTS] (EAS)|
| 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
| 353501 | Effective (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353502 | Expiry (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353503 | Change Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353504 | Employment Status Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353505 | Position Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353506 | Job Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353507 | Department Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353508 | Unit Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
This page (revision-27) was last changed on 26-Nov-2021 10:22 by kparrottTop