TL_SCH_RTI_RC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	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
4	PRIMARY_KEY_NAME1	Character(18)	VARCHAR2(18) NOT NULL	Primary Key Name1
5	PRIMARY_KEY_VALUE1	Character(18)	VARCHAR2(18) NOT NULL	Primary Key Value1
6	PRIMARY_KEY_NAME2	Character(18)	VARCHAR2(18) NOT NULL	Primary Key Name2
7	PRIMARY_KEY_VALUE2	Number(3,0)	SMALLINT NOT NULL	Primary Key Value 2
8	COLUMN_NM	Character(18)	VARCHAR2(18) NOT NULL	Column Name
9	COLUMN_VALUE_CHAR	Character(30)	VARCHAR2(30) NOT NULL	The Column Value (Character) where the RI Instance is created
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
12	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
13	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
14	SCH_START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
15	SCH_END_DATE	Date(10)	DATE	End Date