One or more dollar adjustments (positive or negative) can
exist for each
employee during a payment cycle. Office of the
President includes three months
of cycles in the production
payroll files with our local data warehouse
maintaining
up to one years worth of payment cycles. The data originates from
the payment cycle-produced Payroll Audit
Record (PAR). As one of
the PAR tables, the PARDAT has been split by fiscal
year.
PARDAT is the current year and PARDAT96 is the 1995-96 fiscal
year.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| DOLLARS_ADJ | DOLLARS ADJUSTMENT | NUMBER(9,2) | The dollar amount associated with the dollar balance adjustment number (PAR 2610). |
| DOLLARS_ADJ_IND | DOLLARS ADJUSTMENT INDICATOR | VARCHAR2(1) | The code indicating the specific type of balance being adjusted when the dollar balance element number (PAR 2610) is a GTN balance (E=employment-to-date, F=fiscal year-to-date, Q=quarter-to-date, S=suspended (+)/Prepaid (-) balance, U=user defined balance, Y=calendar year-to-date, D=declining balance, G=GTN, gross-to-net, or BLANK). |
| DOLLARS_TYPE | DOLLARS TYPE CODE | VARCHAR2(4) | |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. |
| ENTRY_SEQ_NO | ENTRY SEQUENCE NUMBER | NUMBER(5) | |
| PAY_CYCLE_CODE | PAY CYCLE CODE | VARCHAR2(2) | The code indicating the pay cycle for which the payroll audit record was generated. |
| PAY_CYCLE_END_DATE | PAY CYCLE END DATE | DATE | The last date in the pay cycle for which the payroll audit record was generated. |
| PRI_GROSS_CTL | PAYROLL AUDIT RECORD GENERATION NUMBER | VARCHAR2(3) | The number identifying the payroll audit record generation produced for the individual. |
| RECORD_TYPE | RECORD TYPE CODE | VARCHAR2(2) |
| Top of this page | Table Description | Data Dictionary | PPS Main Menu |