HP_RPTNG_PERIOD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HP_STATS_FT_DATE | Date(10) | DATE NOT NULL | Stats-Can FT Survey Start Date |
| 2 | HP_FT_TO_DATE | Date(10) | DATE | Stats-Can FT Survey End Date |
| 3 | HP_STATS_PT_DATE | Date(10) | DATE NOT NULL | Stats-Can PT Survey Start Date |
| 4 | HP_PT_TO_DATE | Date(10) | DATE | Stats-Can PT Survey End Date |
| 5 | HP_SABBATICAL_CAT | Character(10) | VARCHAR2(10) NOT NULL |
Sabbatical HR/Action Category
Prompt Table: HP_SABATCL_VW |
| 6 | HP_WORKLOAD_CAT | Character(10) | VARCHAR2(10) NOT NULL |
Wrkload Reductn HR/Act Catgry
Prompt Table: HP_WRKLOAD_VW |
| 7 | HP_OTHERPAID_CAT | Character(10) | VARCHAR2(10) NOT NULL |
Other Paid Leave HR/Act Catgry
Prompt Table: HP_OTHERPAID_VW |
| 8 | HP_UNPAID_CAT | Character(10) | VARCHAR2(10) NOT NULL |
Unpaid Leave HR/Act Catgry
Prompt Table: HP_UNPAID_VW |
| 9 | HP_FT_FILENAME | Character(8) | VARCHAR2(8) NOT NULL | FT Survey Output Filename |
| 10 | HP_PT_FILENAME | Character(8) | VARCHAR2(8) NOT NULL | PT Survey Output Filename |
| 11 | HP_900_PROC_DT | Date(10) | DATE | HPH900CN Process Date |
| 12 | HP_901_PROC_DT | Date(10) | DATE | HPH901CN Process Date |
| 13 | HP_902_PROC_DT | Date(10) | DATE | HPH902CN Process Date |
| 14 | HP_903_PROC_DT | Date(10) | DATE | HPH903CN Process Date |
| 15 | HP_904_PROC_DT | Date(10) | DATE | HPH904CN Process Date |
| 16 | HP_905_PROC_DT | Date(10) | DATE | HPH905CN Process Date |