TL_TA_RSL_MAIN (SQL Table)	Index Back
Time Admin Process Statistics

TL_TA_RSL_MAIN

(SQL Table)

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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 STARTDATETIME DateTime(26) TIMESTAMP Start Datetime

5 ENDDATETIME DateTime(26) TIMESTAMP End Datetime

6 TL_PAY_TIME_CT Number(9,0) DECIMAL(9) NOT NULL Actual Rows Created

7 TL_IPT_CT Number(9,0) DECIMAL(9) NOT NULL IPT Rows Created

8 TL_EXCEPT_CT Number(9,0) DECIMAL(9) NOT NULL Exceptions Created

9 TL_TA_MODE Character(2) VARCHAR2(2) NOT NULL Single field indicating the mode in which the TA process is being run. Used to control the processing flow.
BF=Batch Forecast
BR=Batch Regular Calculation
OF=Online Forecast
OR=Online Regular Calculation

10 TL_TA_RUNTIME Character(15) VARCHAR2(15) NOT NULL Duration (milliseconds)

11 KEEP_IT Character(1) VARCHAR2(1) NOT NULL Field introduced for TA statistics to allow user to indicate if the statistics from a particular run should be preserved despite other clean-up settings.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	STARTDATETIME	DateTime(26)	TIMESTAMP	Start Datetime
5	ENDDATETIME	DateTime(26)	TIMESTAMP	End Datetime
6	TL_PAY_TIME_CT	Number(9,0)	DECIMAL(9) NOT NULL	Actual Rows Created
7	TL_IPT_CT	Number(9,0)	DECIMAL(9) NOT NULL	IPT Rows Created
8	TL_EXCEPT_CT	Number(9,0)	DECIMAL(9) NOT NULL	Exceptions Created
9	TL_TA_MODE	Character(2)	VARCHAR2(2) NOT NULL	Single field indicating the mode in which the TA process is being run. Used to control the processing flow. BF=Batch Forecast BR=Batch Regular Calculation OF=Online Forecast OR=Online Regular Calculation
10	TL_TA_RUNTIME	Character(15)	VARCHAR2(15) NOT NULL	Duration (milliseconds)
11	KEEP_IT	Character(1)	VARCHAR2(1) NOT NULL	Field introduced for TA statistics to allow user to indicate if the statistics from a particular run should be preserved despite other clean-up settings.