EMPLIDDefault Value: ADM_APPL_DEP.EMPLID
INSTITUTION_SETSF_ISET_DEP2_VW(SQL View) |
Index Back |
|---|---|
Deposit Program Information |
| SELECT DISTINCT A.EMPLID , A.INSTITUTION_SET , A.BUSINESS_UNIT FROM PS_SF_ISET_DEP1_VW A WHERE (A.DUE_AMT - A.RECEIVED_AMT - A.WAIVED_AMT) > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: ADM_APPL_DEP.EMPLID |
| 2 | INSTITUTION_SET |
Character(5) | VARCHAR2(5) NOT NULL | Institution Set |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |