GL INTERFACE VARIABLES#

X_INF_VARIABLE_NAME is a fixed lexicon. Variables starting with "32" are used to define interfaces in the IDIF screen that will be created by the UPPHF program

Saved
Value
Displayed ValueSource of DataComments
320001 Execution ID (32) From Execution ID of the UPPHF run
320002 XML Tag (32) Indicates this Rec#/Fld# is for XML tag. You should enter the XML tag in the XML tag field, if XML tag field is not specified, the field name is used as XML tag e.g. <Request> or </Request> as XML tag. You should use one of the following ways to define XML tags: 1) use 320002-XML tag for all Begin and End tags i.e. you specify <Request> and </Request> 2) use 320604-XML Begin tag and 320605-XML End tag. This allows you to use XML tag option to indicate if the XML tag is mandatory or optional. You must not use 320002-XML tag to mix with 320604/320605 definition
320003 Constant Value (32) You should specify the Constant to be used in IDIF Constant Value field
320004 System Date/Time (32) The current system date and time with following, select:to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')You can use derivation expression SUBSTR to retrieve Date Only or Time Only
320005 From Pay Period (32) This field holds the earliest pay period that have been processed from all pay headers This can be used for Header or Trailer record
320006 To Pay Period (32) This field holds the latest pay period that have been processed from all pay headersThis can be used for Header or Trailer record
320007 Pay Header pph_id (32) This field holds the id of the current pay headerThis can be used in the derivation expression to call some internal Wiki functions that needed the pph.id e.g. call Element function to return the value of an element: To retrieve the value of Element 'HOURS COMP TIME'. In Record# 50, Field#20, Variable Name = 'Pay Header PPH_ID', then in derivation expression: P2K_PPAMTS.SPELPAY(~,P2K_PPAMTS.SPGETPEL('HOURS COMP TIME'))
320008 Employment eem_id (32) This field holds the id of the current employment record, from P2K_HR_EMPLOYMENTS
320009 Identity eid_id (32) This field holds the id of the current identity record from P2K_HR_IDENTITIESThis can be used in the derivation expression to call some internal Wiki functions that needed the EID_ID
320010 Person Code (32) From P2K_HR_IDENTITIES, person_code
320011 First Name (32) From P2K_HR_IDENTITIES, first_name
320012 Last Name (32) From P2K_HR_IDENTITIES, last_name
320013 First,Last Name (32) From P2K_HR_IDENTITIES, first_name ', ' last_name
320014 Last,First Name (32) From P2K_HR_IDENTITIES, last_name ', ' first_name
320015 Trial Run (32) From parameter P_TRIAL (Trial Run)The value of 'Y' or 'N' is always returned in P_TRIAL. If NULL is entered, P_TRIAL is set to 'N'
320020 Batch Number (32) From P2K_PR_BATCHES, batch_number
320030 Pay Run Number (32) From P2K_PR_PAY_RUNS, pay_run_number
320031 Pay Run Sequence (32) From P2K_PR_PAY_HEADERS, pay_run_sequence
320040 Hired Date (32) From P2K_HR_EMPLOYMENTS, hire_date
320041 Term Date (32) From P2K_HR_EMPLOYMENTS, termination_date
320042 Seniority Date (32) From P2K_HR_EMPLOYMENTS, seniority_date
320043 First Work Date (32) From P2K_HR_EMPLOYMENTS, first_work_date
320044 Last Work Date (32) From P2K_HR_EMPLOYMENTS, last_work_date
320100 Pay Header Stage From P2K_PR_PAY_HEADERS, pay_header_stage
320101 Pay Number (32) From P2K_PR_PAY_HEADERS, pay_number
320102 Pay Period (32) From P2K_PR_PAY_HEADERS, pay_period
320103 Pay Period Start (32) From P2K_PR_PAY_PERIODS, pay_period_start_date of the pay header
320104 Pay Period End Date (32) From P2K_PR_PAY_PERIODS, pay_period_end_date of the pay header
320105 Pay Issue Date (32) From P2K_PR_PAY_HEADERS, pay_issue_date
320106 Period Fiscal (32) From Pay Period Fiscal of Pay Header
320107 Period Fiscal Start (32) From Fiscal Start Date of Pay Period Fiscal
320108 Period Fiscal End (32) From Fiscal End Date of Pay Period Fiscal
320109 Issue Fiscal (32) From Pay Issue Fiscal of Pay Header
320110 Issue Fiscal Start (32) From Fiscal Start Date of Pay Issue Fiscal
320111 Issue Fiscal End (32) From Fiscal End Date of Pay Issue Fiscal
320200 G/L Company Code (32) From P2K_CM_ENTITIES, GL Company Code
320201 Entity Code (32) From P2K_CM_ENTITIES, Entity Code
320202 Entity Name (32) From P2K_CM_ENTITIES, Entity Name
320203 Payroll Code (32) From P2K_PR_PAYROLLS, Payroll Code
320204 Payroll Desc (32) From P2K_PR_PAYROLLS, Payroll description
320205 Unit Code (32) From P2K_CM_UNITS, Unit Code
320206 Unit Name (32) From P2K_CM_UNIT_DETAILS, Unit Name
320207 Group Code (32) From P2K_CM_GROUPS,Group Code
320208 Group Desc (32) From P2K_CM_GROUP_DETAILS, Group Description
320209 Department Code (32) From Pay Header assignment Department Code on P2K_CM_DEPARTMENTS or Pay Line Department Code if exists
320210 Department Name (32) From Pay Header assignment Department Name on P2K_CM_DEPARTMENT_DETAILS or Pay Line Department name if exists
320211 Job Code (32) From Pay Header assignment Job Code on P2K_CM_JOBS or Pay Line Job Code if exists
320212 Job Title (32) From Pay Header assignment Job Title on P2K_CM_JOB_DETAILS or Pay Line Job Title if exists
320213 Position Code (32) From Pay Header assignment Position Code on P2K_CM_POSITIONS or Pay Line Position Code if exists
320214 Position Title (32) From Pay Header assignment Position Title on P2K_CM_POSITION_DETAILS or Pay Line Position Title if exists
320215 Assignment Code (32) From Pay Header assignment Code on P2K_HR_ASSIGNMENTS or Pay Line assignment Code if exists
320216 Assignment Title (32) From Pay Header assignment Title on P2K_HR_ASSIGNMENT_DETAILS or Pay Line assignment Code Title if exists
320217 Pay Category Code (32) From Pay Header pay_category_code on P2K_PR_PAY_CATEGORIES
320218 Check Number (32) From Pay Header Check Number on P2K_PR_CHECKS
320219 Check Amount (32) From Pay Header Check Amount on P2K_PR_CHECKS
320220 User Name (32) From Pay Header User Name on P2K_AM_USERS
320221 Work State/Prov (32) From Pay Header Work State/Prov on P2K_PR_PAY_HEADERS
320222 Res State/Prov (32) From Pay Header Residence State/Prov on P2K_PR_PAY_HEADERS
320223 Work GEO Code (32) From Pay Header Work Jurisdiction GEO Code on P2K_CM_TAX_JURISDICTIONS
320224 Res GEO Code (32) From Pay Header Residence Jurisdiction GEO Code on P2K_CM_TAX_JURISDICTIONS
320225 Work Jurisdiction (32) From Pay Header Work Jurisdiction on P2K_PR_PAY_HEADERS
320226 Res Jurisdiction (32) From Pay Header Residence Jurisdiction on P2K_PR_PAY_HEADERS
320227 School District (32) From Pay Header School District on P2K_PR_PAY_HEADERS
320230 Std Wage (eas) (32) From Pay Header Assignment Std Wage
320231 Wage Basis (eas) (32) From Pay Header Assignment Wage Basis
320232 Authorization Code (32) Authorization area is from pay header or pay line's assignment, then position, then department
320300 PC Code (32) The PC Code of the current pay line detail or pay amount
320301 PC Abbrev (32) The PC Abbreviation of the current pay line detail or pay amount
320302 PC Amount (32) The PC Amount of the current pay line detail or pay amount
320303 Element Code (32) You should specify the 'Element Code' in IDIF Constant Value
320304 Element PC Value (32) You should specify the 'Element Code' in IDIF Constant ValueIf the PC Code of the current pay line detail or pay amount is in the element, then the PC Amount is included
320305 Element Desc (32) You should specify the 'Element Code' in IDIF Constant Value
320306 Element pph Value (32) You should specify the 'Element Code' in IDIF Constant Valuethis returns the Element Value of this Pay Header PPH_ID
320400 Start Date (ppl) (32) From Pay Line Start Date on P2K_PR_PAY_LINES
320401 Time (ppl) (32) From Pay Line Time on P2K_PR_PAY_LINES
320402 Time Basis (ppl) (32) From Pay Line Time Basis on P2K_PR_PAY_LINES
320403 Std Wage (ppl) (32) From Pay Line Std Wage on P2K_PR_PAY_LINES
320404 Wage Basis (ppl) (32) From Pay Line Wage Basis on P2K_PR_PAY_LINES
320405 Cost Center (ppl) (32) From Pay Line Cost Center on P2K_CM_COST_CENTERS
320406 Cost Center Desc (32) From Pay Line Cost Center description on P2K_CM_COST_CENTERS
320407 Work Order (ppl) (32) From Pay Line Work Order on P2K_PR_PAY_LINES
320408 Reference Info (ppl) (32) From Pay Line Reference Info on P2K_PR_PAY_LINES
320409 Tran Pointer (ppl) (32) From Pay Line Transaction Pointer on P2K_PR_PAY_LINES
320410 Pay Line ID (ppl_id) (32) From Pay Line ID
320411 Pay Line Detail (ppld_id) (32) From Pay Line Detail ID
320500 Wage Rate (ppld) (32) From Pay Line Detail Wage Rate on P2K_PR_PAY_LINE_DETAILS
320501 Rate Basis (ppld) (32) From Pay Line Detail Rate Basis on P2K_PR_PAY_LINE_DETAILS
320502 Tran Pointer (ppld) (32) From Pay Line Detail Transaction Pointer on P2K_PR_PAY_LINE_DETAILS
320600 Total Value (32) 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 = 5070This Total Value is available for Header and Trailer records. Multiple Rec# and Field # are allowed in the Constant field e.g. [611] + [612] + [613] + [623] - [624]. This means calculate the Totals for Rec# 61 Fld# 1 + Rec# 61 Fld# 2 + Rec# 61 Fld# 3 + Rec# 62 Fld# 3 - Rec# 62 Fld# 4. Any arithmetic operator can be used: +, -, *, /Note: The Accum Option and Total Option must be set for the Rec# Fld# that are specified in this Constant field, i.e.Rec# 61 Fld# 1 etc
320601 Detail Record Count (32) Contains the Record Count of each set of Rec# 30-69 in the interface file, i.e. one set of IDIF Record Type of 'DetailRecord', can be used as employee count e.g. if an employee's one detail record generates three different Record types with Rec# 50, 60, 65, it counts as one because it is for one detail recordThis Record Count is available for Header and Trailer records
320602 All Detail Count (32) Contains the Record Count of all Rec# 30-69 in the interface file e.g. if an employee's one detail record generates 3 different Record types with Rec# 50, 60, 65, it counts as 3 because there are 3 entries generated on interface fileThis Record Count is available for Header and Trailer records
320603 User Calc (32) Indicates this Rec#/Fld# will invoke a UserCalc. You should enter the UserCalc Name in the Constant Value field
320604 XML Begin Tag (32) Indicates this Rec#/Fld# is for XML Begin tag You should enter the XML tag in the XML tag field, if XML tag field is not specified, the Field name is used as XML tag. You should specify XML tag option for this field. If XML tag option is not specified, this XML tag is an optional tag. If you use 320604-XML Begin tag to define the XML tags, you must use 320605-XML End tag to pair with the XML Begin tag. You should use one of the following ways to define XML tags:1) use 320002-XML tag for all Begin and End tags i.e. you specify <Request> and </Request> 2) use 320604-XML Begin tag and 320605-XML End tag . This allows you to use XML tag option to indicate if the XML tag is mandatory or optional. You must not use 320002-XML tag to mix with 320604/320605 definition
320605 XML End Tag (32) Indicates this Rec#/Fld# is for XML End tag See 320604- XML Begin tag for detail
320606 UDF (EID) (32) Indicates this Rec#/Fld# contains a UDF value from P2K_HR_IDENTITIES (EID)You must define the UDF on IMUF screen for P2K_HR_IDENTITIES and then enter the value on IEID screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen
320607 UDF (EEM) (32) Indicates this Rec#/Fld# contains a UDF value from P2K_HR_EMPLOYMENTS (EEM)You must define the UDF on IMUF screen for P2K_HR_EMPLOYMENTS and then enter the value on IEEI screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen
320608 UDF (EPS) (32) Indicates this Rec#/Fld# contains a UDF value from P2K_HR_PERSONALS (EPS)You must define the UDF on IMUF screen for P2K_HR_PERSONALS and then enter the value on IEPI screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen
320610 UDF (EASD) (32) Indicates this Rec#/Fld# contains a UDF value from P2K_HR_ASSIGNMENT_DETAILS (EASD)User must define the UDF on IMUF screen for P2K_HR_ASSIGNMENT_DETAILS and then enter the value on IEAS screen Effective date sections. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-UpdateRecord', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen.
320621 UDF (DED) (32) Indicates this Rec#/Fld# contains a UDF value from P2K_CM_ENTITY_DETAILS (DED)User must define the UDF on IMUF screen for P2K_CM_ENTITY_DETAILS and then enter the value on IDEN screen Effective date sections. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen
320623 UDF (DDD) (32) Indicates this Rec#/Fld# contains a UDF value from P2K_CM_DEPARTMENT_DETAILS (EASD)P2K_CM_DEPARTMENT_DETAILS and then enter the value on IDDP screen Effective date sections. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen
320624 UDF (DLN) (32) Indicates this Rec#/Fld# contains a UDF value from P2K_CM_LOCATIONS (DLN)User must define the UDF on IMUF screen for P2K_CM_LOCATIONS and then enter the value on IDLN screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen
320626 UDF (DUD) (32) Indicates this Rec#/Fld# contains a UDF value from P2K_CM_UNIT_DETAILS (DUD)User must define the UDF on IMUF screen for P2K_CM_UNIT_DETAILS and then enter the value on IDUN screen Effective date sections. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen
320628 UDF (DGD) (32) Indicates this Rec#/Fld# contains a UDF value from P2K_CM_GROUP_DETAILS (DGD)User must define the UDF on IMUF screen for P2K_CM_GROUP_DETAILS and then enter the value on IDGR screen Effective date sections. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be Inserted or Updated, you do not need to set up UDF on IMUF screen
320629 UDF (PRN) (32) Indicates this Rec#/Fld# contains a UDF value from P2K_PR_PAY_RUNS (PRN) User must define the UDF on IMUF screen for P2K_PR_PAY_RUNS and then enter the value on IPVP screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen
320630 UDF (PPH) (32) Indicates this Rec#/Fld# contains a UDF value from P2K_PR_PAY_LINES (PPL)User must define the UDF on IMUF screen for P2K_PR_PAY_LINES and then enter the value on IPPH screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen
320631 UDF (PPL) (32)
320650 Statistic Amt (IEST) (65) 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. On IDIF screen, you must enter the IDSC Statistics Code in the Constant Value field
320700 Journal Entry ID (PJE) (32) This field holds the id of the current Journal Entry
320701 Distr Code (PJE) (32) From Distribution Code on P2K_PR_JOURNAL_ENTRIES
320702 Journal Source (PJE) (32) From Journal Source on P2K_PR_JOURNAL_ENTRIES
320703 G/L Post Number (PJE) (32) From GL Post Numberon P2K_PR_JOURNAL_ENTRIES
320704 G/L Post Seq (PJE) (32) From GL Post Sequence on P2K_PR_JOURNAL_ENTRIES
320705 Trial Journal (PJE) (32) From Trial Journal on P2K_PR_JOURNAL_ENTRIES
320750 Journal Detail ID (PJD) (32) This field holds the id of the current Journal Detail
320751 Pay Line ID (PJD) (32) This field holds the PPL_ID of the current Journal Detail
320752 Pay Detail ID (PJD) (32) This field holds the PPLD_ID of the current Journal Detail
320753 Pay Trans ID (PJD) (32) This field holds the PTR_ID of the current Journal Detail
320754 G/L Fund ID (PJD) (32) This field holds the DGF_ID of the current Journal Detail
320755 Time Code PTRC_ID (PJD) (32) This field holds the PTRC_ID of the current Journal Detail
320756 G/L Eff Date (PJD) (32) From GL Effective Date on P2K_PR_JOURNAL_DETAILS
320757 G/L Amount (PJD) (32) From GL Amount on P2K_PR_JOURNAL_DETAILS
320758 G/L Amt DR (PJD) (32) From GL Amount if amount is positive, otherwise 0
320759 G/L Amt CR (PJD) (32) From GL Amount if amount is negative,otherwise 0
320760 G/L Amt-Financial (PJD) (32) From GL Amount if the DGA G/L Account Journal Type for this PJD = '01-Financial', otherwise 0
320761 G/L Amt-Statistical (PJD) (32) From GL Amount if the DGA G/L Account Journal Type for this PJD = '01-Financial', otherwise 0
320762 G/L Amt-Time Usage (PJD) (32) From GL Amount if the PC Usage Code for this PJD pay component = '10- Time', otherwise 0
320763 G/L Amt-Earn Usage (PJD) (32) From GL Amount if the PC Usage Code for this PJD pay component = '11- Earnings', otherwise 0
320764 G/L Amt-Dedn Usage (PJD) (32) From GL Amount if the PC Usage Code for this PJD pay component = '12- Deduction', otherwise 0
320765 G/L Amt-Ben Usage (PJD) (32) From GL Amount if the PC Usage Code for this PJD pay component = '13- Benefit', otherwise 0
320780 Split Percent (PJD) (32) From Split Percent on P2K_PR_JOURNAL_DETAILS
320781 G/L Detail Seq (PJD) (32) From GL Detail Sequence on P2K_PR_JOURNAL_DETAILS
320782 Work Order (PJD) (32) From Work Order on P2K_PR_JOURNAL_DETAILS
320783 G/L Pointer (PJD) (32) From GL Pointer on P2K_PR_JOURNAL_DETAILS
320800 G/L Account ID (DGA) (32) This field holds the id of the G/L Account of current journal entry
320801 G/L Account Code (DGA) (32) From GL Account Code on P2K_CM_GL_ACCOUNTS of current G/L Account
320802 0802 Account Type (DGA) (32) From GL Account Type on P2K_CM_GL_ACCOUNTS of current G/L Account
320803 Journal Type (DGA) (32) From Journal Type on P2K_CM_GL_ACCOUNTS
320804 0804 Account Usage (DGA) (32) From Account Usage on P2K_CM_GL_ACCOUNTS
320805 0805 Account Desc (DGA) (32) From Account Desc on P2K_CM_GL_ACCOUNTS
320806 Distr Mask (DGA) (32) From Distribution Mask on P2K_CM_GL_ACCOUNTS
320807 Affects Costing (DGA) (32) From Affects Costing on P2K_CM_GL_ACCOUNTS
320808 Pre Payroll (DGA) (32) From Pre Payroll on P2K_CM_GL_ACCOUNTS
320809 Post Payroll (DGA) (32) From Post Payroll on P2K_CM_GL_ACCOUNTS
320810 Retain Detail (DGA) (32) From Retain Detail on P2K_CM_GL_ACCOUNTS
320811 Accrued Required (DGA) (32) From Accrued Required on P2K_CM_GL_ACCOUNTS
320812 I/C Required (DGA) (32) From I/C Required on P2K_CM_GL_ACCOUNTS
320813 Posting Date Method (DGA (32) From Posting Date Method on P2K_CM_GL_ACCOUNTS
320814 G/L Acct Suffix (DGA) (32) From GL Acct Suffixon P2K_CM_GL_ACCOUNTS
320815 Acct Charge To (DGA) (32) From Acct Charge To on P2K_CM_GL_ACCOUNTS
320900 Pay Component ID (PPC) (32) This field holds the id of the Pay Component of current journal detail
320901 PC Code (PPC) (32) From PC Code on P2K_PR_PAY_COMPONENTS
320902 PC Abbrev (PPC) (32) From PC Abbreviation on P2K_PR_PAY_COMPONENTS
320903 PC Desc (PPC) (32) From PC Description on P2K_PR_PAY_COMPONENTS
320904 PC Action (PPC) (32) From PC Action on P2K_PR_PAY_COMPONENTS
320905 Store Results (PPC) (32) From Store Results on P2K_PR_PAY_COMPONENTS
320920 PC Usage ID (PCU) (32) This field holds the id of the Pay Component Usage of the pay component of the current journal detail
320921 PC Usage Code (PCU) (32) From PC Usage Code on P2K_PR_PC_USAGES
320922 PC Usage Type (PCU) (32) From PC Usage Type on P2K_PR_PC_USAGES
320923 PC Usage Desc (PCU) (32) From PC Usage Description on P2K_PR_PC_USAGES
320924 Unique Item (PCU) (32) From Unique Item on P2K_PR_PC_USAGES
320925 Mandatory (PCU) (32) From Mandatory on P2K_PR_PC_USAGES
320926 Legislation (PCU) (32) From Legislation on P2K_PR_PC_USAGES
320927 PC G/L Type (PCU) (32) From PC GL Type on P2K_PR_PC_USAGES
321000 Pays Per Year (PPP) (32)