SEV_COM_DSA_VW(SQL View) |
Index Back |
|---|---|
SEVIS DS2019 Comments View |
| SELECT EMPLID , SEV_PRG_NBR , EFFDT , SEV_COMM_ID , SEV_COMMENTS FROM PS_SEV_DS_COMMENT WHERE SEV_COMM_ID = 'DSA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: DS2019_FORM.EMPLID |
| 2 | SEV_PRG_NBR |
Character(9) | VARCHAR2(9) NOT NULL |
SEVIS Program Number
Default Value: DS2019_FORM.SEV_PRG_NBR Prompt Table: SEV_PRG_SP_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: DS2019_FORM.EFFDT |
| 4 | 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 |
| 5 | SEV_COMMENTS | Long Character(500) | VARCHAR2(500) | SEVIS Comments |