SEV_SETUP1_TBL(SQL Table) |
Index Back |
|---|---|
SEVIS Setup Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: ADDRESS_TYP_TBL |
| 2 | 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 |
| 3 | NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Type of Name
Prompt Table: NAME_TYPE_TBL |
| 4 | SEV_URL | Character(254) | VARCHAR2(254) NOT NULL | SEVIS Schema Location |
| 5 | SEV_MLADR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
SEVIS Preferred Name
Prompt Table: ADDRESS_TYP_TBL |
| 6 | SEV_PREF_FMTYPE | Character(3) | VARCHAR2(3) NOT NULL |
SEVIS Preferred Name
Prompt Table: NAME_TYPE_TBL |
| 7 | SEV_PREF_FMDEP | Character(1) | VARCHAR2(1) NOT NULL |
SEVIS Preferred Name
Y/N Table Edit |
| 8 | SEV_PREF_JTYPE | Character(3) | VARCHAR2(3) NOT NULL |
SEVIS Preferred Name
Prompt Table: NAME_TYPE_TBL |
| 9 | SEV_PREF_JDEP | Character(1) | VARCHAR2(1) NOT NULL |
SEVIS Preferred Name
Y/N Table Edit |
| 10 | SEV_PASS_FMTYPE | Character(3) | VARCHAR2(3) NOT NULL |
SEVIS Preferred Name
Prompt Table: NAME_TYPE_TBL |
| 11 | SEV_PASS_FMDEP | Character(1) | VARCHAR2(1) NOT NULL |
SEVIS Preferred Name
Y/N Table Edit |
| 12 | SEV_PASS_JTYPE | Character(3) | VARCHAR2(3) NOT NULL |
SEVIS Preferred Name
Prompt Table: NAME_TYPE_TBL |
| 13 | SEV_PASS_JDEP | Character(1) | VARCHAR2(1) NOT NULL |
SEVIS Preferred Name
Y/N Table Edit |
| 14 | SEV_DUMMY_FNAME | Character(30) | VARCHAR2(30) NOT NULL | SEVIS Preferred Name |