PKG_CALENDAR(SQL Table) |
Index Back |
|---|---|
Calendar Table for Sal PckgSalary Packaging - Calendar table for HR only customers |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |
|
| 2 | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
|
| 3 | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
|
| 4 | Date(10) | DATE | Pay Period End Date | |
| 5 | PAY_BEGIN_DT | Date(10) | DATE | Pay Period Begin Date |