TL_TRSTATUS_AET (SQL Table)	Index Back
Update TR Status AE State Recd This record is used to pass paramater information to the Update TR Status process. The information passed includes either all of the information required to update status for one time reporter ( Empl ID, Rcdn, From Date, To Date, Validation ID) or the Submit ID high level key which identifies the set of Time Reporters in the TL_TMRPT_LIST table which are to be processed.

TL_TRSTATUS_AET

(SQL Table)

Update TR Status AE State Recd

This record is used to pass paramater information to the Update TR Status process. The information passed includes either all of the information required to update status for one time reporter ( Empl ID, Rcdn, From Date, To Date, Validation ID) or the Submit ID high level key which identifies the set of Time Reporters in the TL_TMRPT_LIST table which are to be processed.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 FROM_DT Date(10) DATE From Date

5 TO_DT Date(10) DATE To Date

6 VALIDATION_ID Character(10) VARCHAR2(10) NOT NULL Identifies a Validation Definition

7 VALID_INSTANCE Number(15,0) DECIMAL(15) NOT NULL Last Validation Instance Num

8 SUBMIT_ID Character(34) VARCHAR2(34) NOT NULL Submit ID is used as a high level key to allow concurrent online and batch processes to use the same work data store without conflict. Generally, the Submit ID is composed of the concatenation of OPRID and current date/time stamp, but any unique id will do.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	FROM_DT	Date(10)	DATE	From Date
5	TO_DT	Date(10)	DATE	To Date
6	VALIDATION_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a Validation Definition
7	VALID_INSTANCE	Number(15,0)	DECIMAL(15) NOT NULL	Last Validation Instance Num
8	SUBMIT_ID	Character(34)	VARCHAR2(34) NOT NULL	Submit ID is used as a high level key to allow concurrent online and batch processes to use the same work data store without conflict. Generally, the Submit ID is composed of the concatenation of OPRID and current date/time stamp, but any unique id will do.