TRN_PROF_AET (SQL Table)	Index Back
State Rec for Prof by Criteria This record is used for the AE program used in Budget Training for Creating not delayed Profiles by Criteria.

TRN_PROF_AET

(SQL Table)

State Rec for Prof by Criteria

This record is used for the AE program used in Budget Training for Creating not delayed Profiles by Criteria.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 TRN_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Profile ID

4 PROFILE_CLAUSE Long Character(4000) CLOB Profile SQL Select Clause

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	TRN_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Profile ID
4	PROFILE_CLAUSE	Long Character(4000)	CLOB	Profile SQL Select Clause