TL_TR_STAT_VLD (SQL Table)	Index Back
TR Status Validations The Time Reporter Status Validations table keeps track of each validation instance assigned to a Time Reporter. The validation instance identifies a distinct instance of a certain validation or set of validations that needs to be executed for a Time Reporter's reported time. The validation instance is defined in the Validation Instance table (TL_VALIDATE_INS) which identifies the applicable Validation Definition (TL_VALIDATE_DFN).

TL_TR_STAT_VLD

(SQL Table)

TR Status Validations

The Time Reporter Status Validations table keeps track of each validation instance assigned to a Time Reporter. The validation instance identifies a distinct instance of a certain validation or set of validations that needs to be executed for a Time Reporter's reported time. The validation instance is defined in the Validation Instance table (TL_VALIDATE_INS) which identifies the applicable Validation Definition (TL_VALIDATE_DFN).

Parent record: TL_TR_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: TL_EMPL_DATA

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: TL_EMPL_DATA
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	VALID_INSTANCE	Number(15,0)	DECIMAL(15) NOT NULL	Last Validation Instance Num