EMPLIDPrompt Table: PEOPLE_SRCH
SEV_SCHOOL_CDDefault Value: OPR_DEF_TBL_CS.SEV_SCHOOL_CD
Prompt Table: SEV_SCH_SCTY_PR
SEV_I20_DATE_VW(SQL View) |
Index Back |
|---|---|
SEVIS I-20 Date View |
| SELECT EMPLID , SEV_SCHOOL_CD , TO_DATE FROM PS_I20_FORM A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_I20_FORM B WHERE B.EMPLID = A.EMPLID AND B.SEV_SCHOOL_CD = A.SEV_SCHOOL_CD AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | 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 |
| 3 | TO_DATE | Date(10) | DATE | Latest Date to be sent to PYR |