SSR_APT_ITEM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
3	SSR_APT_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Academic Progress Tracker Instance Number
4	SSR_APT_ITEM_SEQ	Number(6,0)	INTEGER NOT NULL	APT Item Seq
5	SSR_APT_ITEM_PAR	Number(6,0)	INTEGER NOT NULL	Parent Item Seq Nbr
6	SSR_APT_ITEM_FOR	Number(6,0)	INTEGER NOT NULL	Substitute for
7	SSR_ITEM_ID	Character(11)	VARCHAR2(11) NOT NULL	Academic Item ID Prompt Table: SSR_APTAIR_HDVW
8	SSR_ITEM_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Academic Item Type Prompt Table: SSR_ITEM_TYPE
9	SSR_AIR_PAR_ITEM	Character(11)	VARCHAR2(11) NOT NULL	AIR Parent Item ID
10	SSR_GRADE_ITEM_FL	Character(1)	VARCHAR2(1) NOT NULL	Grading Item Type Y/N Table Edit Default Value: N
11	SSR_ENRL_CAT	Character(4)	VARCHAR2(4) NOT NULL	Enrollment Category Prompt Table: SSR_ENRL_CAT
12	SSR_ITEM_WEIGHT	Number(3,0)	SMALLINT NOT NULL	Item Weight
13	SSR_EXAM_ONLY_FL	Character(1)	VARCHAR2(1) NOT NULL	Exam Only Option E=Exclude in selection I=Included O=Exam Only Course Y/N Table Edit Default Value: N
14	SSR_SUBSTITUTED_FL	Character(1)	VARCHAR2(1) NOT NULL	Substituted Y/N Table Edit Default Value: N
15	SSR_SATISFIED_FL	Character(1)	VARCHAR2(1) NOT NULL	Satisfied N=No W=Waived Y=Yes Default Value: N
16	SSR_INCL_IN_CALC	Character(1)	VARCHAR2(1) NOT NULL	Include in Calculation Y/N Table Edit Default Value: Y
17	FREEZE_REC_FL	Character(1)	VARCHAR2(1) NOT NULL	Item Locked Y/N Table Edit Default Value: N
18	SSR_APT_AUTH_EXCPT	Character(2)	VARCHAR2(2) NOT NULL	Authorized Exception AA=Admin Addition
19	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
20	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
21	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
22	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time
23	SSR_NOTE_LONG	Long Character	CLOB	Notes