One or more hour adjustments (positive or negative) can
exist for each employee
during a payment cycle. Office
of the President includes three months of payment
cycles
in the production payroll files with our local data
warehouse maintaining up to one years
worth of payment
cycle. The data originates from the payment
cycle-produced
Payroll Audit Record (PAR). The PARHAT table has been
split by
fiscal year. The PARHAT table is for the current
fiscal year with PARHAT96
containing the 1995-1996 fiscal
year.
| Field Name |
Business Name |
Data Type |
Description |
| EMPLOYEE_ID |
EMPLOYEE ID NUMBER |
VARCHAR2(9) |
The unique employee identification number. |
| ENTRY_SEQ_NO |
ENTRY SEQUENCE NUMBER |
NUMBER(5) |
The sequence number assigned to the record entry. |
| HRS_ADJ |
HOURS ADJUSTMENT |
NUMBER(11,6) |
The number of hours associated with the hours adjustment element
number
(PAR 2480). |
| HRS_TYPE |
HOURS TYPE CODE |
VARCHAR2(4) |
The employee data base (EDB) data element number which is associated
with
the Hours adjustment value (PAR 2490). |
| 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) |
|
