SSR_AIR_ELEM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	SSR_ITEM_ID	Character(11)	VARCHAR2(11) NOT NULL	Academic Item ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	SSR_ITEM_SEQ	Number(6,0)	INTEGER NOT NULL	Sequence Number
5	SSR_CHILD_ITEM_ID	Character(11)	VARCHAR2(11) NOT NULL	Child Item ID Prompt Table: %EDITTABLE3
6	SSR_ITEM_WEIGHT	Number(3,0)	SMALLINT NOT NULL	Item Weight
7	SSR_MAX_ATTMPT	Number(3,0)	SMALLINT NOT NULL	Number of Attempts Allowed Default Value: 1
8	SSR_ENRL_CAT	Character(4)	VARCHAR2(4) NOT NULL	Enrollment Category Prompt Table: SSR_ENRL_CAT
9	DEGREE	Character(8)	VARCHAR2(8) NOT NULL	Degree Prompt Table: DEGREE_INTRN_VW
10	RQ_CONNECT	Character(4)	VARCHAR2(4) NOT NULL	Detail Connector AND=And OR=Or
11	SSR_LPAREN_CNT	Number(1,0)	SMALLINT NOT NULL	Parenthesis
12	SSR_RPAREN_CNT	Number(1,0)	SMALLINT NOT NULL	Parenthesis
13	SSR_ELEM_LVL_AT	Character(2)	VARCHAR2(2) NOT NULL	Element-level Attribute 00=Use default item attributes 20=Add to default attributes 40=Override default attributes Default Value: 00
14	SSR_ELEM_LVL_PM	Character(2)	VARCHAR2(2) NOT NULL	Element-level Parameters 00=Use default item parameters 20=Add to default parameters 40=Override default parameters Default Value: 00
15	SSR_ELEM_LVL_RL	Character(2)	VARCHAR2(2) NOT NULL	Element-level Rules 00=Use default item rules 20=Add to default rules 40=Override default rules Default Value: 00
16	SSR_IN_OPTGRP	Character(1)	VARCHAR2(1) NOT NULL	Part of an option group Y/N Table Edit Default Value: N
17	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
18	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
19	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
20	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time