SEV_PRG_NBRDefault Value: SEV_PRG_SP_TBL.SEV_PRG_NBR
EMPLIDPrompt Table: SEV_RO_EMPL_VW
Y/N Table Edit
Default Value: N
SEV_PRG_OFF_TBL(SQL Table) |
Index Back |
|---|---|
SEVIS Program Officer TableThis record is a child table to SEV_PRG_SP_TBL. It contains the relation between each Program Sponsor and its School Official. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEV_PRG_NBR |
Character(9) | VARCHAR2(9) NOT NULL |
SEVIS Program Number
Default Value: SEV_PRG_SP_TBL.SEV_PRG_NBR |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: SEV_RO_EMPL_VW |
| 3 | SEV_PRIMARY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
SEVIS Primary DSO or ARO
Y/N Table Edit Default Value: N |