SEV_REV_ADDR

(SQL Table)
Index Back

SEVIS Alerts - Address

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code
2 SEV_PRG_NBR Character(9) VARCHAR2(9) NOT NULL SEVIS Program Number
3 SEV_BATCH_ID Character(14) VARCHAR2(14) NOT NULL SEVIS Compare Batch ID
4 SEV_EVENT_NBR Number(5,0) INTEGER NOT NULL SEVIS Alert Detail Number
5 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

6 SEV_COMMUTER Character(1) VARCHAR2(1) NOT NULL SEVIS Commuter

Y/N Table Edit

Default Value: N

7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
9 CITY Character(30) VARCHAR2(30) NOT NULL City
10 STATE Character(6) VARCHAR2(6) NOT NULL State
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
13 ADDRESS1_2 Character(55) VARCHAR2(55) NOT NULL Address Line 1
14 ADDRESS2_2 Character(55) VARCHAR2(55) NOT NULL Address Line 2
15 CITY2 Character(30) VARCHAR2(30) NOT NULL City
16 STATE2 Character(6) VARCHAR2(6) NOT NULL State
17 POSTAL2 Character(12) VARCHAR2(12) NOT NULL Postal Code
18 SEV_IS_VALID Character(1) VARCHAR2(1) NOT NULL SEVIS Is Valid Flag
19 SEV_USADR_EXPCD Character(2) VARCHAR2(2) NOT NULL SEVIS Explanation Code
OB=Campus business address
OH=Campus housing address
OM=Campus mailing address
ON=New mailing address
OO=Other override
OP=New physical address
20 SEV_USADR_EXPTX Character(200) VARCHAR2(200) NOT NULL SEVIS Explanation Code
21 SEV_MLADR_EXPCD Character(2) VARCHAR2(2) NOT NULL SEVIS Explanation Code
OB=Campus business address
OH=Campus housing address
OM=Campus mailing address
ON=New mailing address
OO=Other override
OP=New physical address
22 SEV_MLADR_EXPTX Character(200) VARCHAR2(200) NOT NULL SEVIS Explanation Code