TL_TA_RSL_RULE

(SQL Table)
Index Back

TA Archived Rule Maps

# 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 PRIORITY Number(3,0) SMALLINT NOT NULL Process Order
4 TL_RULE_ID Character(12) VARCHAR2(12) NOT NULL Rule ID
5 RULE_START_DT Date(10) DATE Introduced for TA to track earliest rule period start date for the processing of a batch.
6 RULE_END_DT Date(10) DATE Introduced for TA to track earliest rule period start date for the processing of a batch.
7 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
8 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID
9 START_DTTM DateTime(26) TIMESTAMP Started at
10 END_DTTM DateTime(26) TIMESTAMP Shift End Date/Time
11 TL_TA_RUNTIME Character(15) VARCHAR2(15) NOT NULL Duration (milliseconds)