SCH_ASG_AET

#	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	TL_PROCESSED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Process Status G=Ignored I=In Process M=Mark for Processing N=Preview R=Rejected Y=Processed
5	TL_ORIG_RUN_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	TL_PRCS_RUN_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
10	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
11	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
12	USE_DFLT_WS	Character(1)	VARCHAR2(1) NOT NULL	Indicator for Primary Schedule A=Create Personal Schedule N=Select Predefined Schedule Y=Use Default Schedule
13	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
14	SCHEDULE_GRP	Character(10)	VARCHAR2(10) NOT NULL	Scheduling Organizational Group Code
15	SCHEDULE_ID	Character(16)	VARCHAR2(16) NOT NULL	The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).
16	SCH_CRITERIA_ID	Character(12)	VARCHAR2(12) NOT NULL	Enrollment Group
17	SCH_CRITERIA_EFFDT	Date(10)	DATE	SCH Criteria Eff Date
18	EXISTS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This Flag tells if we should use Exists, or Not Exists as a predicate prefixing the SubQuery. 0=Exists 1=Not Exists
19	ASOFDATE	Date(10)	DATE	As of Date