| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BATCH_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Batch Number
|
| 3 |
WORKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Workgroup
|
| 4 |
WRKGRP_EFFDT |
Date(10) |
DATE |
Workgroup Effective Date
|
| 5 |
RULE_PGM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Rule Program ID
|
| 6 |
RULEPGM_EFFDT |
Date(10) |
DATE |
Rule Program Date
|
| 7 |
START_DTTM |
DateTime(26) |
TIMESTAMP |
Start Date/Time
|
| 8 |
END_DTTM |
DateTime(26) |
TIMESTAMP |
Shift End Date/Time
|
| 9 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 10 |
END_DT |
Date(10) |
DATE |
end date
|
| 11 |
EMPLID_FROM |
Character(11) |
VARCHAR2(11) NOT NULL |
EMPLID (first for a range)
|
| 12 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
Empl ID To
|
| 13 |
TA_COUNT |
Number(15,0) |
DECIMAL(15) NOT NULL |
Utility field used in TA process to hold various counts, such as the number of EEs in a batch.
|
| 14 |
TL_IPT_CT |
Number(9,0) |
DECIMAL(9) NOT NULL |
IPT Rows Created
|
| 15 |
RULE_START_DT |
Date(10) |
DATE |
Introduced for TA to track earliest rule period start date for the processing of a batch.
|
| 16 |
RULE_END_DT |
Date(10) |
DATE |
Introduced for TA to track earliest rule period start date for the processing of a batch.
|
| 17 |
TL_TA_RUNTIME |
Character(15) |
VARCHAR2(15) NOT NULL |
Duration (milliseconds)
|