SAD_APL_TND_STG(SQL Table) |
Index Back |
---|---|
Application Fee TenderStage and Load staging record for ADM_APPL_TENDER |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCC_TEMP_ID | Number(16,0) | DECIMAL(16) NOT NULL | Temp Constituent ID |
2 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
3 | STDNT_CAR_NBR | Number(3,0) | SMALLINT NOT NULL | Student Career Nbr |
4 | ADM_APPL_NBR | Character(8) | VARCHAR2(8) NOT NULL | Application Nbr |
5 | TENDER_CATEGORY | Character(3) | VARCHAR2(3) NOT NULL |
Tender Category
CC=Credit Card CCI=Credit Card In CCO=Credit Card Out CK=Check CKI=Check In CKO=Check Out CS=Cash CSI=Cash In CSO=Cash Out DB=Debit Card DBI=Debit Card In DBO=Debit Card Out DD=Direct Deposit DDI=Direct Debit DDO=Direct Deposit EC=Electronic Check TP=Third Party Check TPI=Third Party Check In WIR=Wire Transfer |
6 | TENDER_AMT | Number(17,2) | DECIMAL(16,2) NOT NULL | Tender Amount |
7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
8 | ORIGNL_TENDER_AMT | Number(17,2) | DECIMAL(16,2) NOT NULL | Original Tender Amount |
9 | ORIGNL_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
10 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
11 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL |
Rate Multiplier
Default Value: 1 |
12 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1 |
13 | SF_PMT_REF_NBR | Character(12) | VARCHAR2(12) NOT NULL | Reference Nbr |
14 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
15 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
16 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
17 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |