EMPLIDPrompt Table: PEOPLE_SRCH
ADM_APPL_NBRAPPL_DEP_NBRACAD_PROGD=Deleted
N=Not Posted
Y=Posted
ADM_APPL_DEP_VW(SQL View) |
Index Back |
|---|---|
Deposit Program Information VW |
| select a.emplid , a.adm_appl_nbr , a.appl_dep_nbr , a.acad_prog , b.due_amt , b.due_dt , b.post_flag from PS_ADM_APPL_DEP_PR a, ps_adm_appl_dep b where a.emplid = b.emplid and a.adm_appl_nbr = b.adm_appl_nbr and a.appl_dep_nbr = b.appl_dep_nbr |
| # | 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 | ADM_APPL_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Application Nbr |
| 3 | APPL_DEP_NBR |
Number(3,0) | SMALLINT NOT NULL | Application Deposit Nbr |
| 4 | ACAD_PROG |
Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
| 5 | DUE_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Due Amount |
| 6 | DUE_DT | Date(10) | DATE | Due Date |
| 7 | POST_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Line Post Flag
D=Deleted N=Not Posted Y=Posted |