COMPANYPAYGROUPPAY_END_DTPY_KB_CN_CAL(SQL Table) |
Index Back |
|---|---|
Payroll Insights CAN CalendarsPayroll Insights Canada Calendars |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 3 | PAY_END_DT |
Date(10) | DATE | Pay Period End Date |
| 4 | PY_RUN_ID | Character(10) | VARCHAR2(10) NOT NULL | Run ID |
| 5 | PAY_BEGIN_DT | Date(10) | DATE | Pay Period Begin Date |
| 6 | PAY_OFF_CYCLE_CAL | Character(1) | VARCHAR2(1) NOT NULL | Off-Cycle Calendar |
| 7 | PAY_SHEETS_RUN | Character(1) | VARCHAR2(1) NOT NULL | Paysheets Run |
| 8 | PAY_CALC_RUN | Character(1) | VARCHAR2(1) NOT NULL | Payroll Calculation Run |
| 9 | PAY_CONFIRM_RUN | Character(1) | VARCHAR2(1) NOT NULL | Payroll Confirmation Run |
| 10 | ADVICE_RUN | Character(1) | VARCHAR2(1) NOT NULL | Advice Forms |
| 11 | PDF_ADVICE | Character(1) | VARCHAR2(1) NOT NULL | PDF Advice Forms |
| 12 | PAYCHECKS_RUN | Character(1) | VARCHAR2(1) NOT NULL | Paychecks |
| 13 | PDF_PAYCHECK | Character(1) | VARCHAR2(1) NOT NULL | PDF Paychecks |
| 14 | GL_INTERFACE_RUN | Character(1) | VARCHAR2(1) NOT NULL | GL Interface Run |
| 15 | CA_GL_INTFC_RUN | Character(1) | VARCHAR2(1) NOT NULL | CA GL Interface Run |
| 16 | PY_COMPANY_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Company description |
| 17 | PY_PAYGROUP_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Paygroup Description |
| 18 | PY_RUNID_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Pay Run ID description |
| 19 | PY_WC_URL | Character(254) | VARCHAR2(254) NOT NULL | Payroll Workcenter URL |
| 20 | PROC_DTTMSTAMP | DateTime(26) | TIMESTAMP | Process Date Timestamp |