EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SFA_MPN_SEQY/N Table Edit
Y/N Table Edit
SFA_PERK_MPN_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID ,A.INSTITUTION ,A.SFA_MPN_SEQ ,A.SFA_MPN_CREATE_DT ,A.SFA_MPN_MULTI_IND ,A.SFA_EMPN_IND ,A.SFA_MPN_SIGN_DT ,A.SFA_MPN_SIGN_TIME ,A.SFA_MPN_CLOSE_DT ,A.SFA_MPN_EXPIRE_DT FROM PS_SFA_PERK_MPN A WHERE A.SFA_MPN_SEQ= ( SELECT MAX(B.SFA_MPN_SEQ) FROM PS_SFA_PERK_MPN B WHERE A.EMPLID=B.EMPLID AND A.INSTITUTION=B.INSTITUTION) |
| # | 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 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 3 | SFA_MPN_SEQ |
Number(3,0) | SMALLINT NOT NULL | MPN Sequence |
| 4 | SFA_MPN_CREATE_DT | DateTime(26) | TIMESTAMP | MPN Created Date |
| 5 | SFA_MPN_MULTI_IND | Character(1) | VARCHAR2(1) NOT NULL |
Multi-Year Indicator
Y/N Table Edit |
| 6 | SFA_EMPN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Electronic MPN
Y/N Table Edit |
| 7 | SFA_MPN_SIGN_DT | Date(10) | DATE | Signature Date |
| 8 | SFA_MPN_SIGN_TIME | Time(15) | TIMESTAMP | Signature Time |
| 9 | SFA_MPN_CLOSE_DT | Date(10) | DATE | MPN Closed Date |
| 10 | SFA_MPN_EXPIRE_DT | Date(10) | DATE | MPN Expire Date |