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 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 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 | |
| 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 Wiki 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) |
