TL_TA_ARCH_BAT

(SQL Table)
Index Back

TA Archived Batches

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 EMPL_EFFDT Date(10) DATE Effective Date from EMPL_DATA
6 TIME_RPTG_STATUS Character(1) VARCHAR2(1) NOT NULL Time Reporter Status
A=Active
I=Inactive
7 START_DT Date(10) DATE Start Date
8 END_DT Date(10) DATE end date
9 ORIG_END_DT Date(10) DATE Unadjusted End Date
10 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
11 COMB_PRI_WRK Number(3,0) SMALLINT NOT NULL Prior SEQ_NBR for combining
12 COMB_NXT_WRK Number(3,0) SMALLINT NOT NULL Next SEQ_NBR for combining
13 IN_BATCH Character(1) VARCHAR2(1) NOT NULL In Batch

Y/N Table Edit

14 RULE_START_DT Date(10) DATE Introduced for TA to track earliest rule period start date for the processing of a batch.
15 RULE_END_DT Date(10) DATE Introduced for TA to track earliest rule period start date for the processing of a batch.