SEV_REV_HEADER (SQL Table)	Index Back
SEVIS Alerts - Header

SEV_REV_HEADER

(SQL Table)

SEVIS Alerts - Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code
Default Value: OPR_DEF_TBL_CS.SEV_SCHOOL_CD
Prompt Table: SEV_SCH_SCTY_PR

2 SEV_PRG_NBR Character(9) VARCHAR2(9) NOT NULL SEVIS Program Number
Default Value: OPR_DEF_TBL_CS.SEV_PRG_NBR
Prompt Table: SEV_PRG_SCTY_PR

3 SEV_BATCH_ID Character(14) VARCHAR2(14) NOT NULL SEVIS Compare Batch ID

4 RECORD_COUNT Number(7,0) INTEGER NOT NULL Count of Records

5 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEV_SCHOOL_CD	Character(15)	VARCHAR2(15) NOT NULL	SEVIS School Code Default Value: OPR_DEF_TBL_CS.SEV_SCHOOL_CD Prompt Table: SEV_SCH_SCTY_PR
2	SEV_PRG_NBR	Character(9)	VARCHAR2(9) NOT NULL	SEVIS Program Number Default Value: OPR_DEF_TBL_CS.SEV_PRG_NBR Prompt Table: SEV_PRG_SCTY_PR
3	SEV_BATCH_ID	Character(14)	VARCHAR2(14) NOT NULL	SEVIS Compare Batch ID
4	RECORD_COUNT	Number(7,0)	INTEGER NOT NULL	Count of Records
5	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.