Created by Corina C Larsen, last modified by Miki Yanagi on Nov 14, 2022
This table contains the payroll feed from Human Resources (HRPRD) that populates the General Ledger. It contains AFFILIATE, CHARTFIELD1, CHARTFIELD2, and CHARTFIELD3 .
Data in this table is loaded nightly, and it feeds to JRNL_HEADER and JRNL_LN.
NOTE -Use of the BUSINESS_UNIT field in this table will generate unreliable results. DO NOT USE. Use BUSINESS_UNIT_GL instead.
| Key | Record.Fieldname | Format | XLAT | Heading Text | Notes |
|---|---|---|---|---|---|
| ACCOUNT - Account | Char10 | Account | |||
| ACCOUNTING_DT - Accounting Date | Date | Acctg Date | |||
| ACCOUNTING_PERIOD - Accounting Period | Num3.0 | Period | |||
| AFFILIATE - Affiliate | Char5 | Affiliate | |||
| ALTACCT - Alternate Account | Char10 | Alt Acct | |||
| APPL_JRNL_ID - Journal Template | Char10 | Template | |||
| AUDIT_ACTN - Action | Char1 | N | Action | ||
| BUDGET_DT - Budget Date | Date | Budg Dt | |||
| BUDGET_LINE_STATUS - Budget Checking Line Status | Char1 | N | Budget Status | ||
| BUDGET_REF - Budget Reference | Char8 | Bud Ref | |||
| BUSINESS_UNIT - Business Unit - DO NOT USE | Char5 | Unit | |||
| BUSINESS_UNIT_GL - GL Business Unit | Char5 | GL Unit | |||
| CHARTFIELD1 - ChartField 1 | Char10 | ChartField 1 | |||
| CHARTFIELD2 - ChartField 2 | Char10 | ChartField 2 | |||
| CHARTFIELD3 - ChartField 3 | Char10 | ChartField 3 | |||
| CLASS_FLD - Class Field | Char5 | Class | |||
| CURRENCY_CD - Currency Code | Char3 | Currency | |||
| DEPTID - Department | Char10 | Dept | |||
| DTTM_STAMP - Date/Time Stamp | DateTm | Date/Time | |||
| FISCAL_YEAR - Fiscal Year | Num4.0 | Year | |||
| FOREIGN_AMOUNT - Foreign Amount | SNm25.3 | Amount | |||
| FOREIGN_CURRENCY - Foreign Currency Code | Char3 | Currency | |||
| FUND_CODE - Fund Code | Char5 | Fund | |||
| GL_DISTRIB_STATUS - Distribution Status | Char1 | N | Status | ||
| IBTRANSACTIONID - Transaction ID | Char36 | Transaction ID | |||
| IN_PROCESS_FLG - In Process | Char1 | In Process | |||
| JOBCODE - Job Code | Char6 | Job Code | |||
| JOURNAL_DATE - Journal Date | Date | Date | |||
| JOURNAL_ID - Journal ID | Char10 | Journal ID | |||
| JOURNAL_LINE - GL Journal Line Number | Num9.0 | Line # | |||
| JOURNAL_LINE_DATE - Journal Line Date | Date | Line Date | |||
| JRNL_LINE_STATUS - Journal Line Status | Char1 | N | Status | ||
| JRNL_LN_REF - Journal Line Reference | Char10 | Ref | |||
| KK_AMOUNT_TYPE - Commitment Control Amount Type | Char1 | N | Amount Type | ||
| LEDGER - Ledger | Char10 | Ledger | |||
| LEDGER_GROUP - Ledger Group | Char10 | Ledger Grp | |||
| LINE_DESCR - Journal Line Description | Char30 | Line Descr | |||
| → | LINE_NBR - Line Number | Num5.0 | Line | ||
| MONETARY_AMOUNT - Monetary Amount | SNm25.3 | Amount | |||
| OFF_CYCLE - Off Cycle ? | Char1 | Off Cycle | |||
| OPEN_ITEM_STATUS - Open Item Status | Char1 | N | Status | ||
| OPERATING_UNIT - Operating Unit | Char8 | Oper Unit | |||
| PAYGROUP - Pay Group | Char3 | Group | |||
| PAY_END_DT - Pay Period End Date | Date | End Date | |||
| POSITION_NBR - Position Number | Char8 | Position | Some position numbers are missing. | ||
| PROCESS_INSTANCE - Process Instance | Num10.0 | Instance | |||
| PRODUCT - Product | Char6 | Product | |||
| PROGRAM_CODE - Program Code | Char5 | Program | |||
| PROJECT_ID - Project | Char15 | Project | |||
| RATE_DIV - Rate Divisor | Num8.8 | Divisor | |||
| RATE_MULT - Rate Multiplier | SNm9.8 | Multiplier | |||
| RT_TYPE - Rate Type | Char5 | Rate Type | |||
| → | RUN_DT - Run Date | Date | Run Date | ||
| RUN_ID - Run ID | Char25 | Run ID | |||
| → | SEQNUM - Sequence number | Num3.0 | SeqNum | ||
| STATISTICS_CODE - Statistics Code | Char3 | Stat | |||
| STATISTIC_AMOUNT - Statistic Amount | SNm15.2 | Stat Amt | |||
| UM_AWARD_FLAG - Award Flag | Char1 | Award Flag | |||
| UM_CODE - Earnings Deduction Code | Char6 | EarnDedCode | |||
| UM_CODE_DESC - Code Description | Char30 | Code Descr | |||
| UM_CODE_TYPE - Earnings or Deduction | Char1 | Earn or Ded | |||
| UM_DEPTID_HR - HR Department | Char10 | HE Dept | |||
| USE_DISTRIBUTION - Use Paycheck Distribution? | Char1 | Use Distrib? |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.