INSTALLATION_CC(SQL Table) |
Index Back |
|---|---|
CC Installation TableThis is the Installation Table for Campus Community. |
| # | 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
Prompt Table: EVENT_TYPE_TBL |
| 3 | EVENT_TYPE_DFL | Character(4) | VARCHAR2(4) NOT NULL |
Default Event Type
Prompt Table: EVENT_TYPE_TBL |
| 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
Prompt Table: SALU_TYPE_VW |
| 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 Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
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
Prompt Table: XL_NAME_PART_VW |
| 21 | MIDDLE_NAME_PART | Character(1) | VARCHAR2(1) NOT NULL |
Middle Name Name Part
Prompt Table: XL_NAME_PART_VW |
| 22 | LAST_NAME_PART | Character(1) | VARCHAR2(1) NOT NULL |
Last Name Name Part
Prompt Table: XL_NAME_PART_VW |
| 23 | TITLE_NAME_PART | Character(1) | VARCHAR2(1) NOT NULL |
Maps a field on NAMES to be used as the Title part.
Prompt Table: XL_NAME_PART_VW |
| 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
Prompt Table: SCC_NID_TYP_VW |
| 28 | ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Phone Usage
Prompt Table: PHONE_USAGE_TBL |
| 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 |
| 31 | SCC_ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Usage Options
Prompt Table: ADDR_USAGE_TBL |
| 32 | SCC_DEL_COMM_PERS | Character(1) | VARCHAR2(1) NOT NULL |
Person
N=No Y=Yes |
| 33 | SCC_DEL_COMM_ORG | Character(1) | VARCHAR2(1) NOT NULL |
Organization
N=No Y=Yes |
| 34 | SCC_DEL_CHECK_PERS | Character(1) | VARCHAR2(1) NOT NULL | Person |
| 35 | SCC_DEL_CHECK_ORG | Character(1) | VARCHAR2(1) NOT NULL | Organization |
| 36 | SCC_DEL_CMNT_PERS | Character(1) | VARCHAR2(1) NOT NULL | Person |
| 37 | SCC_DEL_CMNT_ORG | Character(1) | VARCHAR2(1) NOT NULL | Organization |
| 38 | SCC_ENABLE_FLUID | Character(1) | VARCHAR2(1) NOT NULL |
Field used as a switch on CC-Installation Page - Enable Fluid - On or Off
Y/N Table Edit Default Value: N |
| 39 | SCC_PREF_NM_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
Preferred Name Search
Y/N Table Edit Default Value: N |