INSTALLATION_SA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID_LAST_CS	Number(10,0)	DECIMAL(10) NOT NULL	Last Organization ID Assigned
2	MAIN_RQRMNT_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last Requirement ID
3	RQRMNT_GROUP_LAST	Number(6,0)	INTEGER NOT NULL	Last Requirement Group
4	RQ_SHARE_ID_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last Course Sharing Sequence
5	RQ_PLN_SHR_ID_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last Plan Sharing Sequence
6	COND_SPEC_LAST	Number(6,0)	INTEGER NOT NULL	Last Requirement Condition
7	COND_PROCID_LAST	Number(4,0)	SMALLINT NOT NULL	Last Condition Procedure
8	COURSE_LIST_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last Course List Sequence
9	CRSE_ID_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last Course ID Assigned
10	EQUIV_CRSE_ID_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last Equiv Course ID Assigned
11	EXT_ORG_ID_LAST	Number(10,0)	DECIMAL(10) NOT NULL	Last External Organization ID
12	FACILITY_ID_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last Facility ID Assigned
13	CLASS_NOTE_ID_LAST	Number(4,0)	SMALLINT NOT NULL	Last Class Note ID Assigned
14	ADM_APPL_NBR_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last Application Nbr Assigned
15	TEST_REC_NBR_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last Test Type Rec Nbr
16	ATP_REC_NBR_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last ATP Rec Nbr
17	TERM_WD_REQ_LAST	Number(12,0)	DECIMAL(12) NOT NULL	Last Term Withdrawal Request
18	RQ_AA_OVRD_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last Advisement Override
19	RQ_ENT_GRP_LAST	Number(6,0)	INTEGER NOT NULL	Last Rqrmnt Entity Grp Nbr
20	FACILITY_CONFLICT	Character(1)	VARCHAR2(1) NOT NULL	Status of Facility Y/N Table Edit Default Value: Y
21	EXT_SA_EVENT_LAST	Number(10,0)	DECIMAL(10) NOT NULL	Last External SA Event ID
22	ENRL_TGT_SEQ_LAST	Number(7,0)	INTEGER NOT NULL	Enrollment Target Sequence Number
23	CRS_TOPIC_LNK_LAST	Number(7,0)	INTEGER NOT NULL	Last Topic Link Assigned
24	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
25	DEFAULT_SECT_SIZE	Number(3,0)	SMALLINT NOT NULL	Default Section Size
26	TRANSCIPT_DT_PRT	Character(2)	VARCHAR2(2) NOT NULL	Transcript Date Print C=Print Class Dates N=Do Not Print Any Dates S=Print Session Dates T=Print Term Dates
27	SSR_CLSRSLT_MAX	Number(9,0)	DECIMAL(9) NOT NULL	Max. Class Search Results
28	SSR_CLSRSLT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Class Search Result Option E=Error Message - limit search W=Warning Message Default Value: W
29	SSR_CLS_ERROR_LMT	Number(4,0)	SMALLINT NOT NULL	Error Message Limit Default Value: 250
30	SSR_CLS_WARN_LMT	Number(4,0)	SMALLINT NOT NULL	Warning Message Limit Default Value: 50
31	SSR_CLSRCH_SUBJOPT	Character(2)	VARCHAR2(2) NOT NULL	Class Search Subject Option 10=Drop-Down List Box 20=Prompt Search Default Value: 10
32	SSR_CLSRCH_TXBOPT	Character(1)	VARCHAR2(1) NOT NULL	Show Textbook Detail Y/N Table Edit Default Value: N
33	SSR_GPA_DEC_IND	Character(2)	VARCHAR2(2) NOT NULL	GPA Decimal rouding or truncating flag R0=Round to 0 decimal place R1=Round to 1 decimal place R2=Round to 2 decimal places R3=Round to 3 decimal places T0=Truncate to 0 decimal place T1=Truncate to 1 decimal place T2=Truncate to 2 decimal places T3=Truncate to 3 decimal places Default Value: R3
34	SAA_HOW_USED_AA	Character(1)	VARCHAR2(1) NOT NULL	This field is used to control how academic advisement is used at the installation level A=Academic Advisement N=Not in Use P=Program Guide Default Value: A
35	SCC_CRM_INSTALL	Character(1)	VARCHAR2(1) NOT NULL	CRM for Higher Education Y/N Table Edit Default Value: N
36	SSR_RS_CAN_CNSMPTN	Character(1)	VARCHAR2(1) NOT NULL	Research Enrollment Tracking candidate days or term trigger to be used in the calculation of consumption. D=Days N=None Default Value: N
37	SSR_RS_CND_NBR_LST	Number(12,0)	DECIMAL(12) NOT NULL	Last Candidate Number
38	SSR_ITEM_ID_LAST	Number(11,0)	DECIMAL(11) NOT NULL	Last Academic Item ID
39	SSR_CRS_GRP_LAST	Number(9,0)	DECIMAL(9) NOT NULL	Last Course Group ID
40	SSR_AC_HDR_PREFIX	Character(2)	VARCHAR2(2) NOT NULL	Activity Registry ID Prefix Default Value: C-
41	SSR_AC_CONT_LAST	Number(11,0)	DECIMAL(11) NOT NULL	Last Sequence Number Default Value: 0
42	SSR_AC_DEC_DISPIND	Character(2)	VARCHAR2(2) NOT NULL	GPA Decimal rouding or truncating flag R0=Display 0 decimal place R1=Display 1 decimal place R2=Display 2 decimal places R3=Display 3 decimal places Default Value: R0
43	SSR_AC_ITEM_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Content Item Prefix Default Value: ITX-
44	SSR_AC_ITEM_STEP	Number(4,0)	SMALLINT NOT NULL	Content Item Step Default Value: 10
45	SSR_RSLT_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Result Type
46	SSR_CREATE_RSLTROW	Character(1)	VARCHAR2(1) NOT NULL	Create Initial Result Row N=Do Not Create Initial Result X=Do not use this option Y=Create Initial Result Default Value: X
47	SSR_IAM_DSP_MAXMRK	Character(1)	VARCHAR2(1) NOT NULL	Display Maximum Mark N=Do Not Display Maximum Mark X=Do not use this option Y=Display Maximum Mark Default Value: Y
48	SSR_RS_REQSTID_LST	Number(12,0)	DECIMAL(12) NOT NULL	Last Candidate Number
49	SSR_BLIND_GRADED	Character(1)	VARCHAR2(1) NOT NULL	This field indicates if blind grading is active N=Do not Use Y=Override Display Values Y/N Table Edit
50	SSR_ANID_LENGTH	Number(2,0)	SMALLINT NOT NULL	Length of Anonymous ID
51	SSR_ANID_MIN_LEN	Number(2,0)	SMALLINT NOT NULL	Minimum Anonymous ID Length Default Value: 1
52	SSR_ENR_SYNC_COMMT	Number(6,0)	INTEGER NOT NULL	APT Enrollment Sync Commit Default Value: 20