TL_RT_SUM_TEMP(SQL Table) |
Index Back |
|---|---|
Summary of Rptd TimeThis record stores the summary of Rptd time data to be printed by the Time Audit Report |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPL_CNT | Number(12,0) | DECIMAL(12) NOT NULL | Employee Count |
| 3 | PUNCH_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Global Punch Types
0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer |
| 4 | PUNCH_TYPE_NAME_1 | Character(15) | VARCHAR2(15) NOT NULL | Punch Type Indicator |
| 5 | NUM_OF_EMPLOYEES_A | Number(6,0) | INTEGER NOT NULL | Number of Employees (Status A) |
| 6 | NUM_OF_EMPLOYEES_C | Number(6,0) | INTEGER NOT NULL | Number of Employees (Status C) |
| 7 | NUM_OF_EMPLOYEES_D | Number(6,0) | INTEGER NOT NULL | Number of Employees (Status D) |