INSTALLATION_CC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CREATE_RCP_RELATE	Character(1)	VARCHAR2(1) NOT NULL	Create Reciprocal Relationship Y/N Table Edit Default Value: N
2	EVENT_TYPE_CRS	Character(4)	VARCHAR2(4) NOT NULL	Course Event Type
3	EVENT_TYPE_DFL	Character(4)	VARCHAR2(4) NOT NULL	Default Event Type
4	SEX_RELATED	Character(1)	VARCHAR2(1) NOT NULL	Default for All Gender
5	REL_ID_ADDR	Character(4)	VARCHAR2(4) NOT NULL	Determines the type of Address. Defined to conform with Email and Phone types. BILL=Billing BUSN=Business CAMP=Campus CELL=Cellular DORM=Dormitory FAX=FAX HOME=Home MAIL=Mailing OTR=Other OTR2=Other2 PERM=Permanent PGR1=Pager 1 PGR2=Pager 2 PREF=Preferred TELX=Telex VTRN=Veteran WORK=Work Prompt Table: HCR_ADDR_TYP_I
6	PRIMARY_ID_ADDR	Character(4)	VARCHAR2(4) NOT NULL	Determines the type of Address. Defined to conform with Email and Phone types. BILL=Billing BUSN=Business CAMP=Campus CELL=Cellular DORM=Dormitory FAX=FAX HOME=Home MAIL=Mailing OTR=Other OTR2=Other2 PERM=Permanent PGR1=Pager 1 PGR2=Pager 2 PREF=Preferred TELX=Telex VTRN=Veteran WORK=Work Prompt Table: HCR_ADDR_TYP_I
7	SALUTATION_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Salutation Type
8	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: PSROLEDEFN
9	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type Prompt Table: ADDRESS_TYP_TBL
10	E_ADDR_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Email Type BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other
11	VISITOR_ID_LAST	Number(16,0)	DECIMAL(16) NOT NULL	Last Visitor ID
12	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN). Prompt Table: PSCLASSDEFN
13	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work
14	SYMBOLICID	Character(8)	VARCHAR2(8) NOT NULL	The foreign key linking the PSOPRDEFN table to PSACCESSPRFL Prompt Table: PSACCESSPRFL
15	SEV_EXT_BATCH_ID	Character(14)	VARCHAR2(14) NOT NULL	SEVIS Extract Batch ID
16	SCC_CHECKLIST_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Checklist Type. ADC=Condition List CML=Communication List HIR=Hiring MED=Medical OTH=Other PRM=Promise RQL=Requirements List SAL=Staff Assignment List TER=Termination TRN=Training XFR=Transfer
17	SCC_ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Home Address Type Prompt Table: ADDRESS_TYP_TBL
18	ADDR_TYPE1	Character(4)	VARCHAR2(4) NOT NULL	Determines the type of Address. Defined to conform with Email and Phone types. BILL=Billing BUSN=Business CAMP=Campus CELL=Cellular DORM=Dormitory FAX=FAX HOME=Home MAIL=Mailing OTR=Other PERM=Permanent PGR1=Pager 1 PGR2=Pager 2 PREF=Preferred TELX=Telex WORK=Work Prompt Table: ADDRESS_TYP_TBL
19	NAME_PART	Character(1)	VARCHAR2(1) NOT NULL	Part of Name F=First L=Last M=Middle T=Title U=Full Default Value: U
20	FIRST_NAME_PART	Character(1)	VARCHAR2(1) NOT NULL	First Name Name Part
21	MIDDLE_NAME_PART	Character(1)	VARCHAR2(1) NOT NULL	Middle Name Name Part
22	LAST_NAME_PART	Character(1)	VARCHAR2(1) NOT NULL	Last Name Name Part
23	TITLE_NAME_PART	Character(1)	VARCHAR2(1) NOT NULL	Maps a field on NAMES to be used as the Title part.
24	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name Default Value: PRI Prompt Table: NAME_TYPE_TBL
25	NAME_PARSE_OPTION	Character(4)	VARCHAR2(4) NOT NULL	Name Parsing ADD=Parse @ Initial Add Entry Only EVER=Parse at Every Name Change NO=No Name Parsing Default Value: NO
26	SCC_NID_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
27	SCC_NID_TYP_LOAD	Character(6)	VARCHAR2(6) NOT NULL	National ID Type
28	ADDR_USAGE	Character(10)	VARCHAR2(10) NOT NULL	Phone Usage
29	SCC_MULT_LANG	Character(1)	VARCHAR2(1) NOT NULL	Support multiple languages Y/N Table Edit Default Value: N
30	SCC_MULT_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Support multiple methods Y/N Table Edit Default Value: N