TL_APPRV_AET (SQL Table)	Index Back
Approvals AE State Record Approvals AE State Record

TL_APPRV_AET

(SQL Table)

Approvals AE State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 AUDITRECNAME Character(15) VARCHAR2(15) NOT NULL Audit Record Name

3 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.

4 EXIST Character(1) VARCHAR2(1) NOT NULL Currency Exist

5 RECUSE Number(5,0) INTEGER NOT NULL Record Use. Audit Option bit values

6 TL_APRV_RETRO Character(1) VARCHAR2(1) NOT NULL Field introduced to support continuation of pre-AWE approval model for payable time.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AUDITRECNAME	Character(15)	VARCHAR2(15) NOT NULL	Audit Record Name
3	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
4	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Currency Exist
5	RECUSE	Number(5,0)	INTEGER NOT NULL	Record Use. Audit Option bit values
6	TL_APRV_RETRO	Character(1)	VARCHAR2(1) NOT NULL	Field introduced to support continuation of pre-AWE approval model for payable time.