SSR_RS_SUPRS_CA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INST_CAR_SCTY
3	SSR_RS_CANDIT_NBR	Character(12)	VARCHAR2(12) NOT NULL	Last Candidate Number
4	SSR_RS_SUPER_NBR	Number(3,0)	SMALLINT NOT NULL	Last Candidate Number
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
7	SCC_CAF_ATTR_SEQ	Number(4,0)	SMALLINT NOT NULL	Attribute Sequence
8	SCC_CAF_ATTRIB_NM	Character(20)	VARCHAR2(20) NOT NULL	Common Attribute Prompt Table: %EDITTABLE18
9	SCC_CAF_ATTR_VAL	Character(20)	VARCHAR2(20) NOT NULL	Attribute Value
10	SCC_CAF_ATTR_NVAL	Number(32,11)	DECIMAL(31,11) NOT NULL	Numeric Value
11	SCC_CAF_ATTR_DVAL	Date(10)	DATE	Date Value
12	SCC_CAF_ATTR_TVAL	Character(50)	VARCHAR2(50) NOT NULL	Text Value
13	SCC_CAF_ATTR_TIME	Time(15)	TIMESTAMP	Time Value
14	SCC_CAF_ATTR_YNO	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Value Y/N Table Edit
15	SCC_CAF_ATTR_LVAL	Long Character	CLOB	Long Text Value
16	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
17	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
18	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
19	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time