EMPLIDPrompt Table: PEOPLE_SRCH
ADM_APPL_NBRAPPL_DEP_NBRDefault Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL
A=Automatic
M=Manual
D=Deleted
N=Not Posted
Y=Posted
Default Value: N
ADM_APPL_DEP(SQL Table) |
Index Back |
|---|---|
Deposit InformationADM_APPL_DEP is used to record information regarding an enrollment deposit related to an admission application. |
| # | 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 | DEPOSIT_FEE_CD | Character(6) | VARCHAR2(6) NOT NULL | Deposit Fee Code |
| 5 | DUE_DT | Date(10) | DATE | Due Date |
| 6 | DUE_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Due Amount |
| 7 | RECEIVED_DT | Date(10) | DATE | Certificate Received Date |
| 8 | RECEIVED_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Received Amount |
| 9 | WAIVED_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Waived Amount |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 12 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 13 | CALC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Calculated Method
A=Automatic M=Manual |
| 14 | POST_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Line Post Flag
D=Deleted N=Not Posted Y=Posted Default Value: N |