| Column Name
|
Label
|
Column Type
|
Allow NULL
|
PK
|
FK
|
| SARADAP_PIDM
|
SARADAP_PIDM
|
NUMBER(8,0)
|
No
|
*
|
*
|
| SARADAP_TERM_CODE_ENTRY
|
SARADAP_TERM_CODE_ENTRY
|
VARCHAR2(6)
|
No
|
*
|
*
|
| SARADAP_APPL_NO
|
SARADAP_APPL_NO
|
NUMBER(2,0)
|
No
|
*
|
*
|
| SARADAP_LEVL_CODE
|
SARADAP_LEVL_CODE
|
VARCHAR2(2)
|
Yes
|
|
*
|
| SARADAP_APPL_DATE
|
SARADAP_APPL_DATE
|
DATE
|
No
|
|
|
| SARADAP_APST_CODE
|
SARADAP_APST_CODE
|
VARCHAR2(1)
|
No
|
|
*
|
| SARADAP_APST_DATE
|
SARADAP_APST_DATE
|
DATE
|
No
|
|
|
| SARADAP_MAINT_IND
|
SARADAP_MAINT_IND
|
VARCHAR2(1)
|
No
|
|
|
| SARADAP_ADMT_CODE
|
SARADAP_ADMT_CODE
|
VARCHAR2(2)
|
Yes
|
|
*
|
| SARADAP_STYP_CODE
|
SARADAP_STYP_CODE
|
VARCHAR2(1)
|
No
|
|
*
|
| SARADAP_CAMP_CODE
|
SARADAP_CAMP_CODE
|
VARCHAR2(3)
|
Yes
|
|
*
|
| SARADAP_SITE_CODE
|
SARADAP_SITE_CODE
|
VARCHAR2(3)
|
Yes
|
|
*
|
| SARADAP_COLL_CODE_1
|
SARADAP_COLL_CODE_1
|
VARCHAR2(2)
|
Yes
|
|
*
|
| SARADAP_DEGC_CODE_1
|
SARADAP_DEGC_CODE_1
|
VARCHAR2(6)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_1
|
SARADAP_MAJR_CODE_1
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_COLL_CODE_2
|
SARADAP_COLL_CODE_2
|
VARCHAR2(2)
|
Yes
|
|
*
|
| SARADAP_DEGC_CODE_2
|
SARADAP_DEGC_CODE_2
|
VARCHAR2(6)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_2
|
SARADAP_MAJR_CODE_2
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_RESD_CODE
|
SARADAP_RESD_CODE
|
VARCHAR2(1)
|
No
|
|
*
|
| SARADAP_FULL_PART_IND
|
SARADAP_FULL_PART_IND
|
VARCHAR2(1)
|
Yes
|
|
|
| SARADAP_SESS_CODE
|
SARADAP_SESS_CODE
|
VARCHAR2(1)
|
Yes
|
|
*
|
| SARADAP_WRSN_CODE
|
SARADAP_WRSN_CODE
|
VARCHAR2(2)
|
Yes
|
|
*
|
| SARADAP_INTV_CODE
|
SARADAP_INTV_CODE
|
VARCHAR2(1)
|
Yes
|
|
*
|
| SARADAP_FEE_IND
|
SARADAP_FEE_IND
|
VARCHAR2(1)
|
Yes
|
|
|
| SARADAP_FEE_DATE
|
SARADAP_FEE_DATE
|
DATE
|
Yes
|
|
|
| SARADAP_ACTIVITY_DATE
|
SARADAP_ACTIVITY_DATE
|
DATE
|
No
|
|
|
| SARADAP_RATE_CODE
|
SARADAP_RATE_CODE
|
VARCHAR2(5)
|
Yes
|
|
*
|
| SARADAP_EGOL_CODE
|
SARADAP_EGOL_CODE
|
VARCHAR2(2)
|
Yes
|
|
*
|
| SARADAP_EDLV_CODE
|
SARADAP_EDLV_CODE
|
VARCHAR2(3)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_1
|
SARADAP_MAJR_CODE_CONC_1
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_DEPT_CODE
|
SARADAP_DEPT_CODE
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_SBGI_CODE
|
SARADAP_SBGI_CODE
|
VARCHAR2(6)
|
Yes
|
|
*
|
| SARADAP_RECR_CODE
|
SARADAP_RECR_CODE
|
VARCHAR2(3)
|
Yes
|
|
*
|
| SARADAP_RTYP_CODE
|
SARADAP_RTYP_CODE
|
VARCHAR2(2)
|
Yes
|
|
*
|
| SARADAP_DEPT_CODE_2
|
SARADAP_DEPT_CODE_2
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_2
|
SARADAP_MAJR_CODE_CONC_2
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_PROGRAM_1
|
SARADAP_PROGRAM_1
|
VARCHAR2(12)
|
Yes
|
|
*
|
| SARADAP_TERM_CODE_CTLG_1
|
SARADAP_TERM_CODE_CTLG_1
|
VARCHAR2(6)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_1_2
|
SARADAP_MAJR_CODE_1_2
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_DEPT_CODE_1_2
|
SARADAP_DEPT_CODE_1_2
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_1_2
|
SARADAP_MAJR_CODE_CONC_1_2
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_1_3
|
SARADAP_MAJR_CODE_CONC_1_3
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_121
|
SARADAP_MAJR_CODE_CONC_121
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_122
|
SARADAP_MAJR_CODE_CONC_122
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_123
|
SARADAP_MAJR_CODE_CONC_123
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_MINR_1_1
|
SARADAP_MAJR_CODE_MINR_1_1
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_MINR_1_2
|
SARADAP_MAJR_CODE_MINR_1_2
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_PROGRAM_2
|
SARADAP_PROGRAM_2
|
VARCHAR2(12)
|
Yes
|
|
*
|
| SARADAP_TERM_CODE_CTLG_2
|
SARADAP_TERM_CODE_CTLG_2
|
VARCHAR2(6)
|
Yes
|
|
*
|
| SARADAP_LEVL_CODE_2
|
SARADAP_LEVL_CODE_2
|
VARCHAR2(2)
|
Yes
|
|
*
|
| SARADAP_CAMP_CODE_2
|
SARADAP_CAMP_CODE_2
|
VARCHAR2(3)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_2_2
|
SARADAP_MAJR_CODE_2_2
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_DEPT_CODE_2_2
|
SARADAP_DEPT_CODE_2_2
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_211
|
SARADAP_MAJR_CODE_CONC_211
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_212
|
SARADAP_MAJR_CODE_CONC_212
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_213
|
SARADAP_MAJR_CODE_CONC_213
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_221
|
SARADAP_MAJR_CODE_CONC_221
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_222
|
SARADAP_MAJR_CODE_CONC_222
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_CONC_223
|
SARADAP_MAJR_CODE_CONC_223
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_MINR_2_1
|
SARADAP_MAJR_CODE_MINR_2_1
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_MAJR_CODE_MINR_2_2
|
SARADAP_MAJR_CODE_MINR_2_2
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_CURR_RULE_1
|
SARADAP_CURR_RULE_1
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CMJR_RULE_1_1
|
SARADAP_CMJR_RULE_1_1
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_11_1
|
SARADAP_CCON_RULE_11_1
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_11_2
|
SARADAP_CCON_RULE_11_2
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_11_3
|
SARADAP_CCON_RULE_11_3
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CMJR_RULE_1_2
|
SARADAP_CMJR_RULE_1_2
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_12_1
|
SARADAP_CCON_RULE_12_1
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_12_2
|
SARADAP_CCON_RULE_12_2
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_12_3
|
SARADAP_CCON_RULE_12_3
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CMNR_RULE_1_1
|
SARADAP_CMNR_RULE_1_1
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CMNR_RULE_1_2
|
SARADAP_CMNR_RULE_1_2
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CURR_RULE_2
|
SARADAP_CURR_RULE_2
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CMJR_RULE_2_1
|
SARADAP_CMJR_RULE_2_1
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_21_1
|
SARADAP_CCON_RULE_21_1
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_21_2
|
SARADAP_CCON_RULE_21_2
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_21_3
|
SARADAP_CCON_RULE_21_3
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CMJR_RULE_2_2
|
SARADAP_CMJR_RULE_2_2
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_22_1
|
SARADAP_CCON_RULE_22_1
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_22_2
|
SARADAP_CCON_RULE_22_2
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CCON_RULE_22_3
|
SARADAP_CCON_RULE_22_3
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CMNR_RULE_2_1
|
SARADAP_CMNR_RULE_2_1
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_CMNR_RULE_2_2
|
SARADAP_CMNR_RULE_2_2
|
NUMBER(8,0)
|
Yes
|
|
*
|
| SARADAP_WEB_ACCT_MISC_IND
|
SARADAP_WEB_ACCT_MISC_IND
|
VARCHAR2(1)
|
Yes
|
|
|
| SARADAP_WEB_CASHIER_USER
|
SARADAP_WEB_CASHIER_USER
|
VARCHAR2(30)
|
Yes
|
|
|
| SARADAP_WEB_TRANS_NO
|
SARADAP_WEB_TRANS_NO
|
NUMBER(8,0)
|
Yes
|
|
|
| SARADAP_WEB_AMOUNT
|
SARADAP_WEB_AMOUNT
|
NUMBER(12,2)
|
Yes
|
|
|
| SARADAP_WEB_RECEIPT_NUMBER
|
SARADAP_WEB_RECEIPT_NUMBER
|
NUMBER(8,0)
|
Yes
|
|
|
| SARADAP_WAIV_CODE
|
SARADAP_WAIV_CODE
|
VARCHAR2(4)
|
Yes
|
|
*
|
| SARADAP_DATA_ORIGIN
|
SARADAP_DATA_ORIGIN
|
VARCHAR2(30)
|
Yes
|
|
|
| SARADAP_USER_ID
|
SARADAP_USER_ID
|
VARCHAR2(30)
|
Yes
|
|
|