SCH_RSV_RTI_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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	SCH_RTI_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Schedule trigger points for resolving shedules for RTI A=Assign Schedule S=Schedule Definition T=Time Reporter Profile W=Workgroup change
6	PRIMARY_KEY_NAME1	Character(18)	VARCHAR2(18) NOT NULL	Primary Key Name1
7	PRIMARY_KEY_NAME2	Character(18)	VARCHAR2(18) NOT NULL	Primary Key Name2
8	PRIMARY_KEY_VALUE2	Number(3,0)	SMALLINT NOT NULL	Primary Key Value 2
9	PRIMARY_KEY_VALUE1	Character(18)	VARCHAR2(18) NOT NULL	Primary Key Value1
10	COLUMN_NM	Character(18)	VARCHAR2(18) NOT NULL	Column Name
11	COLUMN_VALUE_CHAR	Character(30)	VARCHAR2(30) NOT NULL	The Column Value (Character) where the RI Instance is created
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
14	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
15	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
16	START_DT	Date(10)	DATE	Start Date
17	END_DT	Date(10)	DATE	end date
18	PUNCH_TEXT	Character(75)	VARCHAR2(75) NOT NULL	Text
19	TL_START_DATE	Date(10)	DATE	Start Date