!!!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 %%zebra-table ||Saved\\Value||Displayed Value||Source of Data||Comments | 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 headers|This can be used for Header or Trailer record | 320007 | Pay Header pph_id (32) | This field holds the id of the current pay header|This can be used in the derivation expression to call some internal [{$applicationname}] 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| | 320009 | Identity eid_id (32) | This field holds the id of the current identity record|this can be used in the derivation expression to call some internal [{$applicationname}] functions that needed the [EID_ID] | 320010 | Person Code (32) | From Employee eid.person_code| | 320011 | First Name (32) | From Employee eid.first_name| | 320012 | Last Name (32) | From Employee eid.last_name| | 320013 | First,Last Name (32) |From Employee eid.first_name ', ' eid.last_name | | 320014 | Last,First Name (32) | From Employee eid.last_name ', ' eid.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 Pay Header Batch pbt.batch_number| | 320030 | Pay Run Number (32) |From Pay Run prn.pay_run_number | | 320031 | Pay Run Sequence (32) |From Pay Header pph.pay_run_sequence | | 320040 | Hired Date (32) | From Employment eem.hire_date| | 320041 | Term Date (32) | From Employment eem.termination_date| | 320042 | Seniority Date (32) |From Employment eem.seniority_date | | 320043 | First Work Date (32) |From Employment eem.first_work_date | | 320044 | Last Work Date (32) | From Employment eem.last_work_date| | 320100 | Pay Header Stage | From Pay Header pph.pay_header_stage| | 320101 | Pay Number (32) | From Pay Header pph.pay_number| | 320102 | Pay Period (32) | From Pay Header ppp.pay_period| | 320103 | Pay Period Start (32) |From ppp.pay_period_start_date of the pay header | | 320104 | Pay Period End Date (32) |From ppp.pay_period_end_date of the pay header | | 320105 | Pay Issue Date (32) | From Pay Header pph.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 GL Company Code of Pay Header Entity| | 320201 | Entity Code (32) | From Pay Header Entity Code| | 320202 | Entity Name (32) | From Pay Header Entity Name| | 320203 | Payroll Code (32) |From Pay Header Payroll Code | | 320204 | Payroll Desc (32) | From Pay Header Payroll description| | 320205 | Unit Code (32) | From Pay Header Unit Code| | 320206 | Unit Name (32) | From Pay Header Unit Name| | 320207 | Group Code (32) | From Pay Header Group Code | | 320208 | Group Desc (32) | From Pay Header Group Description| | 320209 | Department Code (32) |From Pay Header assignment Department Code or Pay Line Department Code if exists | | 320210 | Department Name (32) | From Pay Header assignment Department Code Name or Pay Line Department Code name if exists| | 320211 | Job Code (32) | From Pay Header assignment Job Code or Pay Line Job Code if exists| | 320212 | Job Title (32) | From Pay Header assignment Job Code Title or Pay Line Job Code Title if exists| | 320213 | Position Code (32) | From Pay Header assignment Position Code or Pay Line Position Code if exists| | 320214 | Position Title (32) | From Pay Header assignment Position Code Title or Pay Line Position Code Title if exists| | 320215 | Assignment Code (32) | From Pay Header assignment Code or Pay Line assignment Code if exists| | 320216 | Assignment Title (32) | From Pay Header assignment Code Title or Pay Line assignment Code Title if exists| | 320217 | Pay Category Code (32) | From Pay Header pay_category_code| | 320218 | Check Number (32) | From Pay Header Check Number| | 320219 | Check Amount (32) | From Pay Header Check Amount| | 320220 | User Name (32) | From User Name of Pay Header| | 320221 | Work State/Prov (32) |From Pay Header Work State/Prov | | 320222 | Res State/Prov (32) | From Pay Header Residence State/Prov| | 320223 | Work GEO Code (32) | From Pay Header Work Jurisdiction GEO Code| | 320224 | Res GEO Code (32) | From Pay Header Residence Jurisdiction GEO Code| | 320225 | Work Jurisdiction (32) |From Pay Header Work Jurisdiction | | 320226 | Res Jurisdiction (32) | From Pay Header Residence Jurisdiction| | 320227 | School District (32) | From Pay Header School District| | 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) | | | 320301 | PC Abbrev (32) | | | 320302 | PC Amount (32) | | | 320303 | Element Code (32) | | | 320304 | Element PC Value (32) | | | 320305 | Element Desc (32) | | | 320306 | Element pph Value (32) | | | 320400 | Start Date (ppl) (32) | | | 320401 | Time (ppl) (32) | | | 320402 | Time Basis (ppl) (32) | | | 320403 | Std Wage (ppl) (32) | | | 320404 | Wage Basis (ppl) (32) | | | 320405 | Cost Center (ppl) (32) | | | 320406 | Cost Center Desc (32) | | | 320407 | Work Order (ppl) (32) | | | 320408 | Reference Info (ppl) (32) | | | 320409 | Tran Pointer (ppl) (32) | | | 320410 | Pay Line ID (ppl_id) (32) | | | 320411 | Pay Line Detail (ppld_id) (32) | | | 320500 | Wage Rate (ppld) (32) | | | 320501 | Rate Basis (ppld) (32) | | | 320502 | Tran Pointer (ppld) (32) | | | 320600 | Total Value (32) | | | 320601 | Detail Record Count (32) | | | 320602 | All Detail Count (32) | | | 320603 | User Calc (32) | | | 320604 | XML Begin Tag (32) | | | 320605 | XML End Tag (32) | | | 320606 | UDF (EID) (32) | | | 320607 | UDF (EEM) (32) | | | 320608 | UDF (EPS) (32) | | | 320610 | UDF (EASD) (32) | | | 320621 | UDF (DED) (32) | | | 320623 | UDF (DDD) (32) | | | 320624 | UDF (DLN) (32) | | | 320626 | UDF (DUD) (32) | | | 320628 | UDF (DGD) (32) | | | 320629 | UDF (PRN) (32) | | | 320630 | UDF (PPH) (32) | | | 320631 | UDF (PPL) (32) | | | 320650 | Statistic Amt (IEST) (65) | | | 320700 | Journal Entry ID (PJE) (32) | | | 320701 | Distr Code (PJE) (32) | | | 320702 | Journal Source (PJE) (32) | | | 320703 | G/L Post Number (PJE) (32) | | | 320704 | G/L Post Seq (PJE) (32) | | | 320705 | Trial Journal (PJE) (32) | | | 320750 | Journal Detail ID (PJD) (32) | | | 320751 | Pay Line ID (PJD) (32) | | | 320752 | Pay Detail ID (PJD) (32) | | | 320753 | Pay Trans ID (PJD) (32) | | | 320754 | G/L Fund ID (PJD) (32) | | | 320755 | Time Code PTRC_ID (PJD) (32) | | | 320756 | G/L Eff Date (PJD) (32) | | | 320757 | G/L Amount (PJD) (32) | | | 320758 | G/L Amt DR (PJD) (32) | | | 320759 | G/L Amt CR (PJD) (32) | | | 320760 | G/L Amt-Financial (PJD) (32) | | | 320761 | G/L Amt-Statistical (PJD) (32) | | | 320762 | G/L Amt-Time Usage (PJD) (32) | | | 320763 | G/L Amt-Earn Usage (PJD) (32) | | | 320764 | G/L Amt-Dedn Usage (PJD) (32) | | | 320765 | G/L Amt-Ben Usage (PJD) (32) | | | 320780 | Split Percent (PJD) (32) | | | 320781 | G/L Detail Seq (PJD) (32) | | | 320782 | Work Order (PJD) (32) | | | 320783 | G/L Pointer (PJD) (32) | | | 320800 | G/L Account ID (DGA) (32) | | | 320801 | G/L Account Code (DGA) (32) | | | 320802 | 0802 Account Type (DGA) (32) | | | 320803 | Journal Type (DGA) (32) | | | 320804 | 0804 Account Usage (DGA) (32) | | | 320805 | 0805 Account Desc (DGA) (32) | | | 320806 | Distr Mask (DGA) (32) | | | 320807 | Affects Costing (DGA) (32) | | | 320808 | Pre Payroll (DGA) (32) | | | 320809 | Post Payroll (DGA) (32) | | | 320810 | Retain Detail (DGA) (32) | | | 320811 | Accrued Required (DGA) (32) | | | 320812 | I/C Required (DGA) (32) | | | 320813 | Posting Date Method (DGA (32) | | | 320814 | G/L Acct Suffix (DGA) (32) | | | 320815 | Acct Charge To (DGA) (32) | | | 320900 | Pay Component ID (PPC) (32) | | | 320901 | PC Code (PPC) (32) | | | 320902 | PC Abbrev (PPC) (32) | | | 320903 | PC Desc (PPC) (32) | | | 320904 | PC Action (PPC) (32) | | | 320905 | Store Results (PPC) (32) | | | 320920 | PC Usage ID (PCU) (32) | | | 320921 | PC Usage Code (PCU) (32) | | | 320922 | PC Usage Type (PCU) (32) | | | 320923 | PC Usage Desc (PCU) (32) | | | 320924 | Unique Item (PCU) (32) | | | 320925 | Mandatory (PCU) (32) | | | 320926 | Legislation (PCU) (32) | | | 320927 | PC G/L Type (PCU) (32) | | | 321000 | Pays Per Year (PPP) (32) | | %%