TL_TA_RSL_MAIN(SQL Table) |
Index Back |
|---|---|
Time Admin Process Statistics |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | STARTDATETIME | DateTime(26) | TIMESTAMP | Start Datetime |
| 3 | ENDDATETIME | DateTime(26) | TIMESTAMP | End Datetime |
| 4 | TL_PAY_TIME_CT | Number(9,0) | DECIMAL(9) NOT NULL | Payable Time Row Count |
| 5 | TL_FRCT_TIME_CT | Number(9,0) | DECIMAL(9) NOT NULL | Forecasted Time Row Count |
| 6 | TL_IPT_CT | Number(9,0) | DECIMAL(9) NOT NULL | IPT Row Count |
| 7 | TL_EXCEPT_CT | Number(9,0) | DECIMAL(9) NOT NULL | Exceptions Row Count |
| 8 | TL_RSL_BAT_BTN | Character(1) | VARCHAR2(1) NOT NULL | View Batch Stats |
| 9 | TL_RSL_SECT_BTN | Character(1) | VARCHAR2(1) NOT NULL | AE Section Stats |
| 10 | TL_TA_RUNTIME | Character(15) | VARCHAR2(15) NOT NULL | Run Time |
| 11 | TL_FORECASTED_IND | Character(1) | VARCHAR2(1) NOT NULL | Forecast Payable Time |