SEV_DS_DEP_COMM (SQL Table)	Index Back
SEVIS DS2019 Comments

SEV_DS_DEP_COMM

(SQL Table)

SEVIS DS2019 Comments

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: DS2019_DEP.EMPLID

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

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: DS2019_DEP.EFFDT

4 SEV_DEP_EMPLID Character(11) VARCHAR2(11) NOT NULL SEVIS Dependent ID
Default Value: DS2019_DEP.SEV_DEP_EMPLID

5 SEV_COMM_ID Character(4) VARCHAR2(4) NOT NULL SEVIS Comment ID
DSA=Subject/Field Remarks
DSB=Funding Comments
DSD=Other Reason
I20A=School Fund Type
I20C=Education Comment
I20D=Dependent Termination Other
I20E=Other Expenses
I20F=Funding Remarks
I20G=Create Remarks
I20O=Other Reason
I20R=Proficiency Reason
I20S=Other Source Funds
I20T=Transferred From
Default Value: DSD

6 SEV_COMMENTS Long Character(500) VARCHAR2(500) SEVIS Comments

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: DS2019_DEP.EMPLID
2	SEV_PRG_NBR	Character(9)	VARCHAR2(9) NOT NULL	SEVIS Program Number Default Value: DS2019_DEP.SEV_PRG_NBR Prompt Table: SEV_PRG_SP_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: DS2019_DEP.EFFDT
4	SEV_DEP_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	SEVIS Dependent ID Default Value: DS2019_DEP.SEV_DEP_EMPLID
5	SEV_COMM_ID	Character(4)	VARCHAR2(4) NOT NULL	SEVIS Comment ID DSA=Subject/Field Remarks DSB=Funding Comments DSD=Other Reason I20A=School Fund Type I20C=Education Comment I20D=Dependent Termination Other I20E=Other Expenses I20F=Funding Remarks I20G=Create Remarks I20O=Other Reason I20R=Proficiency Reason I20S=Other Source Funds I20T=Transferred From Default Value: DSD
6	SEV_COMMENTS	Long Character(500)	VARCHAR2(500)	SEVIS Comments