The Payroll Control Records (PCR) table provides the header information such as payroll period/cycle type, beginning and ending dates, fiscal year information about each pay cycle/period contained in the detailed EDWEXP expense distribution table. The data is extracted on a monthly basis from the Expense Distribution Workfile (EDW) which is created by the process that prints the PPP5302 Distribution of Payroll Expense Report and produces the payroll expense file for the DaFIS Financial system. Those familiar with the old EDW file know this information as the 'type 1' record. Security for the EDWPCR table is controlled through views giving departments access to all records that pertain to EDWEXP expenses incurred by their department employees during the fiscal year. The table view is SG#PCR with the # being the Screen Group designation.
Similar to the other historical data tables (i.e. PAR, ETH), the EDWPCR table has been
split by fiscal year: the EDWPCR is for the current fiscal year while EDWPCR98 is for the
1997-98 fiscal year.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| PCR_LAST_PGM | LAST PGM | NUMBER(2) | Under research. |
| PCR_CHECK_DATE | CHECK DATE | DATE | The check date for this pay period. |
| PCR_END_DATE | CYCLE_END_DATE | DATE | This pay cycle end date. |
| PCR_CYCLE_1_TYPE | CYCLE 1 CYCLE TYPE | VARCHAR2(2) | The code indicating the pay cycle. (values are B1=first biweekly, B2=second biweekly, MA=monthly arrears, MO=monthly regular) |
| PCR_CYCLE_1_BEGIN_DATE | CYCLE 1 BEGIN DATE | DATE | The beginning date of this pay cycle. |
| PCR_CYCLE_1_WORK_DAYS | CYCLE 1 WORK DAYS | NUMBER(2) | The number of work days in this pay cycle. |
| PCR_CYCLE_1_DEDN_SCHED | CYCLE 1 DEDUCTION SCHEDULE | NUMBER(1) | The number identifying the deduction schedule for this pay cycle. (values are 1=first schedule, 2=second schedule) |
| PCR_CYCLE_2_TYPE | CYCLE 2 CYCLE TYPE | VARCHAR2(2) | The code indicating pay cycle. (values are B1=first biweekly, B2=second biweekly, MA=monthly arrears, MO=monthly regular) |
| PCR_CYCLE_2_BEGIN_DATE | CYCLE 2 BEGIN DATE | DATE | The beginning date of this pay cycle. |
| PCR_CYCLE_2_WORK_DAYS | CYCLE 2 WORK DAYS | NUMBER(2) | The number of work days in this pay cycle. |
| PCR_CYCLE_2_DEDN_SCHED | CYCLE 2 DEDUCTION SCHEDULE | NUMBER(1) | The number identifying the deduction schedule for this pay cycle. (values are 1=first schedule, 2=second schedule) |
| PCR_CYCLE_3_TYPE | CYCLE 3 CYCLE TYPE | VARCHAR2(2) | The code indicating the pay cycle. (values are B1=first biweekly, B2=second biweekly, MA=monthly arrears, MO=monthly regular) |
| PCR_CYCLE_3_BEGIN_DATE | CYCLE 3 BEGIN DATE | DATE | The beginning date of this pay cycle. |
| PCR_CYCLE_3_WORK_DAYS | CYCLE 3 WORK DAYS | NUMBER(2) | The number of work days in this pay cycle. |
| PCR_CYCLE_3_DEDN_SCHED | CYCLE 3 DEDUCTION SCHEDULE | NUMBER(1) | The number identifying the deduction schedule for this pay cycle. (values are 1=first schedule, 2=second schedule) |
| PCR_CYCLE_4_TYPE | CYCLE 4 CYCLE TYPE | VARCHAR2(2) | The code identifying the pay cycle. (values are B1=first biweekly, B2=second biweekly, MA=monthly arrears, MO=monthly regular) |
| PCR_CYCLE_4_BEGIN_DATE | CYCLE 4 BEGIN DATE | DATE | The beginning date of this pay cycle. |
| PCR_CYCLE_4_WORK_DAYS | CYCLE 4 WORK DAYS | NUMBER(2) | The number of work days in this pay cycle. |
| PCR_CYCLE_4_DEDN_SCHED | CYCLE 4 DEDUCTION SCHEDULE | NUMBER(1) | The number identifying the deduction schedule for this pay cycle. (values are 1=first schedule, 2=second schedule) |
| PCR_PER_END_MONTH | PERIOD END MONTH | NUMBER(2) | The ending month for this pay period. |
| PCR_PER_END_QTR | PERIOD END QUARTER | NUMBER(1) | The ending quarter for this pay period. |
| PCR_PER_END_YEAR | PERIOD END YEAR | NUMBER(1) | The ending year for this pay period. |
| PCR_PER_END_FY | PERIOD END FISCAL YEAR | NUMBER(1) | The ending fiscal year for this pay period. |
| PCR_NEXT_MONTH | NEXT CYCLE BEGIN MONTH | NUMBER(2) | The beginning month of the next pay cycle. |
| PCR_NEXT_QTR | NEXT CYCLE BEGIN QUARTER | NUMBER(1) | The beginning quarter of the next pay cycle. |
| PCR_NEXT_YEAR | NEXT CYCLE BEGIN YEAR | NUMBER(1) | The beginning year of the next pay cycle. |
| PCR_NEXT_FY | NEXT CYCLE BEGIN FISCAL YEAR | NUMBER(1) | The beginning fiscal year of the next pay cycle. |
| PCR_LAST_DAY_IN_MONTH | LAST DAY IN MONTH | NUMBER(2) | The last day of the month for this pay cycle. |
| PCR_QUARTER_CODE | QUARTER CODE | NUMBER(1) | The quarter code for this pay cycle. |
| PCR_LAST_EDB_GEN | LAST EDB GENERATION | NUMBER(2) | The generation number code of the last EDB update cycle. |
| PCR_LAST_PAYROLL_GEN | LAST PAYROLL GENERATION | NUMBER(3) | The generation number of the last payroll computation cycle. |
| PCR_THF_SEQ_NO | THF SEQUENCE NUMBER | NUMBER(5) | The Transaction Holding File (THF) Sequence number. |
| PCR_THF-RE_EDIT | THF RE-EDIT INDICATOR | VARCHAR2(1) | The Transaction Holding File (THF) re-edit indicator code. |
| PCR_UNKNOWN_DATE | UNKNOWN DATE | DATE | Under research. There seems to be a date in this field, although the CPWSXEDR record layout indicates a six character filler. |
| PCR_BIWKLY_WRK_DAYS | BIWEEKLY WORK DAYS | NUMBER(2) | The number of work days in the bi-weekly pay cycle. |
| PCR_PROCESS_MONTH | PROCESS MONTH | NUMBER(2) | Under research. |
| PCR_ET_MONTH | ET FISCAL YEAR-MONTH | VARCHAR2(4) | The fiscal Year and Month of this payroll period. This field has also been split into FISCAL_YEAR and FISCAL_PERIOD. |
| PCR_DAY_ARRAY_1 | PCR DAY ARRAY ONE | VARCHAR2(31) | The first of four day arrays consisting of 31 bytes each. Each byte is actually numeric. Not sure how this is used, but the first array has numbers in it ranging from 0-5? |
| PCR_DAY_ARRAY_2 | PCR DAY ARRAY TWO | VARCHAR2(31) | Not used. |
| PCR_DAY_ARRAY_3 | PCR DAY ARRAY THREE | VARCHAR2(31) | Not used. |
| PCR_DAY_ARRAY_4 | PCR DAY ARRAY FOUR | VARCHAR2(31) | Not used. |
| FISCAL_YEAR | FISCAL YEAR | VARCHAR2(4) | The four-digit Fiscal Year of this payroll period. |
| FISCAL_PERIOD | FISCAL PERIOD/MONTH | VARCHAR2(2) | The fiscal Period or Month of this payroll period. |
| Top of this page | Data Dictionary | PPS Main Menu |
Send Comments to PPS Data Warehouse Support at: paysys-support@ucdavis.edu
Last Updated: June 30, 1999