| Columns | 
| Name | 
Description | 
Datatype ¿? | 
Allow Null | 
| opr_s | 
Operator initials  | 
CHAR(3) | 
no | 
| stamp_l | 
Record modification stamp  | 
NUMBER(10) | 
no | 
| fld_sec1_s | 
Field security code [1]  | 
CHAR(4) | 
yes | 
| fld_sec2_s | 
Field security code [2]  | 
CHAR(4) | 
yes | 
| fld_sec3_s | 
Field security code [3]  | 
CHAR(4) | 
yes | 
| fld_sec4_s | 
Field security code [4]  | 
CHAR(4) | 
yes | 
| fld_sec5_s | 
Field security code [5]  | 
CHAR(4) | 
yes | 
| fld_sec6_s | 
Field security code [6]  | 
CHAR(4) | 
yes | 
| fld_sec7_s | 
Field security code [7]  | 
CHAR(4) | 
yes | 
| fld_sec8_s | 
Field security code [8]  | 
CHAR(4) | 
yes | 
| fld_sec9_s | 
Field security code [9]  | 
CHAR(4) | 
yes | 
| fld_sec10_s | 
Field security code [10]  | 
CHAR(4) | 
yes | 
| fld_sec11_s | 
Field security code [11]  | 
CHAR(4) | 
yes | 
| fld_sec12_s | 
Field security code [12]  | 
CHAR(4) | 
yes | 
| fld_sec13_s | 
Field security code [13]  | 
CHAR(4) | 
yes | 
| fld_sec14_s | 
Field security code [14]  | 
CHAR(4) | 
yes | 
| fld_sec15_s | 
Field security code [15]  | 
CHAR(4) | 
yes | 
| fld_sec16_s | 
Field security code [16]  | 
CHAR(4) | 
yes | 
| fld_sec17_s | 
Field security code [17]  | 
CHAR(4) | 
yes | 
| fld_sec18_s | 
Field security code [18]  | 
CHAR(4) | 
yes | 
| fld_sec19_s | 
Field security code [19]  | 
CHAR(4) | 
yes | 
| fld_sec20_s | 
Field security code [20]  | 
CHAR(4) | 
yes | 
| fld_sec21_s | 
Field security code [21]  | 
CHAR(4) | 
yes | 
| fld_sec22_s | 
Field security code [22]  | 
CHAR(4) | 
yes | 
| fld_sec23_s | 
Field security code [23]  | 
CHAR(4) | 
yes | 
| fld_sec24_s | 
Field security code [24]  | 
CHAR(4) | 
yes | 
| fld_sec25_s | 
Field security code [25]  | 
CHAR(4) | 
yes | 
| fld_sec26_s | 
Field security code [26]  | 
CHAR(4) | 
yes | 
| fld_sec27_s | 
Field security code [27]  | 
CHAR(4) | 
yes | 
| fld_sec28_s | 
Field security code [28]  | 
CHAR(4) | 
yes | 
| fld_sec29_s | 
Field security code [29]  | 
CHAR(4) | 
yes | 
| fld_sec30_s | 
Field security code [30]  | 
CHAR(4) | 
yes | 
| fld_sec31_s | 
Field security code [31]  | 
CHAR(4) | 
yes | 
| fld_sec32_s | 
Field security code [32]  | 
CHAR(4) | 
yes | 
| fld_sec33_s | 
Field security code [33]  | 
CHAR(4) | 
yes | 
| fld_sec34_s | 
Field security code [34]  | 
CHAR(4) | 
yes | 
| fld_sec35_s | 
Field security code [35]  | 
CHAR(4) | 
yes | 
| fld_sec36_s | 
Field security code [36]  | 
CHAR(4) | 
yes | 
| fld_sec37_s | 
Field security code [37]  | 
CHAR(4) | 
yes | 
| flow_s | 
Application flow code  | 
CHAR(4) | 
yes | 
| app_let_s | 
Application letter code
  This array contains only those letters
  to which the user has access.  | 
VARCHAR2(80) | 
yes | 
| usr_opt_s | 
User option code
  This array contains only those user options
  to which the user has access.  | 
VARCHAR2(20) | 
yes | 
| app_stat1_s | 
Application status [1]  | 
CHAR(4) | 
yes | 
| app_stat2_s | 
Application status [2]  | 
CHAR(4) | 
yes | 
| app_stat3_s | 
Application status [3]  | 
CHAR(4) | 
yes | 
| app_stat4_s | 
Application status [4]  | 
CHAR(4) | 
yes | 
| app_stat5_s | 
Application status [5]  | 
CHAR(4) | 
yes | 
| app_stat6_s | 
Application status [6]  | 
CHAR(4) | 
yes | 
| app_stat7_s | 
Application status [7]  | 
CHAR(4) | 
yes | 
| app_stat8_s | 
Application status [8]  | 
CHAR(4) | 
yes | 
| app_stat9_s | 
Application status [9]  | 
CHAR(4) | 
yes | 
| app_stat10_s | 
Application status [10]  | 
CHAR(4) | 
yes | 
| app_stat11_s | 
Application status [11]  | 
CHAR(4) | 
yes | 
| app_stat12_s | 
Application status [12]  | 
CHAR(4) | 
yes | 
| app_stat13_s | 
Application status [13]  | 
CHAR(4) | 
yes | 
| app_stat14_s | 
Application status [14]  | 
CHAR(4) | 
yes | 
| app_stat15_s | 
Application status [15]  | 
CHAR(4) | 
yes | 
| app_stat16_s | 
Application status [16]  | 
CHAR(4) | 
yes | 
| app_stat17_s | 
Application status [17]  | 
CHAR(4) | 
yes | 
| app_stat18_s | 
Application status [18]  | 
CHAR(4) | 
yes | 
| app_stat19_s | 
Application status [19]  | 
CHAR(4) | 
yes | 
| app_stat20_s | 
Application status [20]  | 
CHAR(4) | 
yes | 
| app_stat21_s | 
Application status [21]  | 
CHAR(4) | 
yes | 
| app_stat22_s | 
Application status [22]  | 
CHAR(4) | 
yes | 
| app_stat23_s | 
Application status [23]  | 
CHAR(4) | 
yes | 
| app_stat24_s | 
Application status [24]  | 
CHAR(4) | 
yes | 
| app_stat25_s | 
Application status [25]  | 
CHAR(4) | 
yes | 
| app_stat26_s | 
Application status [26]  | 
CHAR(4) | 
yes | 
| app_stat27_s | 
Application status [27]  | 
CHAR(4) | 
yes | 
| app_stat28_s | 
Application status [28]  | 
CHAR(4) | 
yes | 
| app_stat29_s | 
Application status [29]  | 
CHAR(4) | 
yes | 
| app_stat30_s | 
Application status [30]  | 
CHAR(4) | 
yes | 
| app_stat31_s | 
Application status [31]  | 
CHAR(4) | 
yes | 
| app_stat32_s | 
Application status [32]  | 
CHAR(4) | 
yes | 
| app_stat33_s | 
Application status [33]  | 
CHAR(4) | 
yes | 
| app_stat34_s | 
Application status [34]  | 
CHAR(4) | 
yes | 
| app_stat35_s | 
Application status [35]  | 
CHAR(4) | 
yes | 
| app_stat36_s | 
Application status [36]  | 
CHAR(4) | 
yes | 
| app_stat37_s | 
Application status [37]  | 
CHAR(4) | 
yes | 
| dr_def_new_status_s | 
Default application status for DR option  | 
CHAR(4) | 
yes | 
| s_app_mod_c | 
User may access corresponding application menu option (Y/N)  | 
VARCHAR2(30) | 
yes | 
| s_mod_addr_c | 
Modify address information (Y/N)  | 
CHAR(1) | 
yes | 
| s_mod_doc_c | 
Modify document list (Y/N/R)
  Y - can modify all list elements
  N - cannot modify any list elements
  R - can modify only unrestricted list elements  | 
CHAR(1) | 
yes | 
| s_over_rplan_c | 
Override rate plan (Y/N)  | 
CHAR(1) | 
yes | 
| s_appr_priv_c | 
Auto-approval privilege (Y/N)  | 
CHAR(1) | 
yes | 
| s_mod_exp_c | 
Change approval expiration date (Y/N)  | 
CHAR(1) | 
yes | 
| s_mod_eff_c | 
Modify effective date (Y/N)  | 
CHAR(1) | 
yes | 
| s_app_vend_c | 
WS default application/vendor (A/V)  | 
CHAR(1) | 
yes | 
| s_apprv_tot_exp_c | 
Approval based on total exposure (Y/N)  | 
CHAR(1) | 
yes | 
| s_new_note_first_c | 
Display newer follow-up dates before old dates (Y/N)  | 
CHAR(1) | 
yes | 
| new_app_stat_s | 
Application status for new applications  | 
CHAR(4) | 
yes | 
| def_nxt_own1_s | 
Default next owner initials [1]  | 
CHAR(3) | 
yes | 
| def_nxt_own2_s | 
Default next owner initials [2]  | 
CHAR(3) | 
yes | 
| def_nxt_own3_s | 
Default next owner initials [3]  | 
CHAR(3) | 
yes | 
| def_nxt_own4_s | 
Default next owner initials [4]  | 
CHAR(3) | 
yes | 
| def_nxt_own5_s | 
Default next owner initials [5]  | 
CHAR(3) | 
yes | 
| def_nxt_own6_s | 
Default next owner initials [6]  | 
CHAR(3) | 
yes | 
| def_nxt_own7_s | 
Default next owner initials [7]  | 
CHAR(3) | 
yes | 
| def_nxt_own8_s | 
Default next owner initials [8]  | 
CHAR(3) | 
yes | 
| def_nxt_own9_s | 
Default next owner initials [9]  | 
CHAR(3) | 
yes | 
| def_nxt_own10_s | 
Default next owner initials [10]  | 
CHAR(3) | 
yes | 
| def_nxt_own11_s | 
Default next owner initials [11]  | 
CHAR(3) | 
yes | 
| def_nxt_own12_s | 
Default next owner initials [12]  | 
CHAR(3) | 
yes | 
| def_nxt_own13_s | 
Default next owner initials [13]  | 
CHAR(3) | 
yes | 
| def_nxt_own14_s | 
Default next owner initials [14]  | 
CHAR(3) | 
yes | 
| def_nxt_own15_s | 
Default next owner initials [15]  | 
CHAR(3) | 
yes | 
| def_nxt_own16_s | 
Default next owner initials [16]  | 
CHAR(3) | 
yes | 
| def_nxt_own17_s | 
Default next owner initials [17]  | 
CHAR(3) | 
yes | 
| def_nxt_own18_s | 
Default next owner initials [18]  | 
CHAR(3) | 
yes | 
| def_nxt_own19_s | 
Default next owner initials [19]  | 
CHAR(3) | 
yes | 
| def_nxt_own20_s | 
Default next owner initials [20]  | 
CHAR(3) | 
yes | 
| def_nxt_own21_s | 
Default next owner initials [21]  | 
CHAR(3) | 
yes | 
| def_nxt_own22_s | 
Default next owner initials [22]  | 
CHAR(3) | 
yes | 
| def_nxt_own23_s | 
Default next owner initials [23]  | 
CHAR(3) | 
yes | 
| def_nxt_own24_s | 
Default next owner initials [24]  | 
CHAR(3) | 
yes | 
| def_nxt_own25_s | 
Default next owner initials [25]  | 
CHAR(3) | 
yes | 
| def_nxt_own26_s | 
Default next owner initials [26]  | 
CHAR(3) | 
yes | 
| def_nxt_own27_s | 
Default next owner initials [27]  | 
CHAR(3) | 
yes | 
| def_nxt_own28_s | 
Default next owner initials [28]  | 
CHAR(3) | 
yes | 
| def_nxt_own29_s | 
Default next owner initials [29]  | 
CHAR(3) | 
yes | 
| def_nxt_own30_s | 
Default next owner initials [30]  | 
CHAR(3) | 
yes | 
| def_nxt_own31_s | 
Default next owner initials [31]  | 
CHAR(3) | 
yes | 
| def_nxt_own32_s | 
Default next owner initials [32]  | 
CHAR(3) | 
yes | 
| def_nxt_own33_s | 
Default next owner initials [33]  | 
CHAR(3) | 
yes | 
| def_nxt_own34_s | 
Default next owner initials [34]  | 
CHAR(3) | 
yes | 
| def_nxt_own35_s | 
Default next owner initials [35]  | 
CHAR(3) | 
yes | 
| def_nxt_own36_s | 
Default next owner initials [36]  | 
CHAR(3) | 
yes | 
| def_nxt_own37_s | 
Default next owner initials [37]  | 
CHAR(3) | 
yes | 
| def_letter1_1_s | 
Default letter1 [1]  | 
CHAR(6) | 
yes | 
| def_letter1_2_s | 
Default letter1 [2]  | 
CHAR(6) | 
yes | 
| def_letter1_3_s | 
Default letter1 [3]  | 
CHAR(6) | 
yes | 
| def_letter1_4_s | 
Default letter1 [4]  | 
CHAR(6) | 
yes | 
| def_letter1_5_s | 
Default letter1 [5]  | 
CHAR(6) | 
yes | 
| def_letter1_6_s | 
Default letter1 [6]  | 
CHAR(6) | 
yes | 
| def_letter1_7_s | 
Default letter1 [7]  | 
CHAR(6) | 
yes | 
| def_letter1_8_s | 
Default letter1 [8]  | 
CHAR(6) | 
yes | 
| def_letter1_9_s | 
Default letter1 [9]  | 
CHAR(6) | 
yes | 
| def_letter1_10_s | 
Default letter1 [10]  | 
CHAR(6) | 
yes | 
| def_letter1_11_s | 
Default letter1 [11]  | 
CHAR(6) | 
yes | 
| def_letter1_12_s | 
Default letter1 [12]  | 
CHAR(6) | 
yes | 
| def_letter1_13_s | 
Default letter1 [13]  | 
CHAR(6) | 
yes | 
| def_letter1_14_s | 
Default letter1 [14]  | 
CHAR(6) | 
yes | 
| def_letter1_15_s | 
Default letter1 [15]  | 
CHAR(6) | 
yes | 
| def_letter1_16_s | 
Default letter1 [16]  | 
CHAR(6) | 
yes | 
| def_letter1_17_s | 
Default letter1 [17]  | 
CHAR(6) | 
yes | 
| def_letter1_18_s | 
Default letter1 [18]  | 
CHAR(6) | 
yes | 
| def_letter1_19_s | 
Default letter1 [19]  | 
CHAR(6) | 
yes | 
| def_letter1_20_s | 
Default letter1 [20]  | 
CHAR(6) | 
yes | 
| def_letter1_21_s | 
Default letter1 [21]  | 
CHAR(6) | 
yes | 
| def_letter1_22_s | 
Default letter1 [22]  | 
CHAR(6) | 
yes | 
| def_letter1_23_s | 
Default letter1 [23]  | 
CHAR(6) | 
yes | 
| def_letter1_24_s | 
Default letter1 [24]  | 
CHAR(6) | 
yes | 
| def_letter1_25_s | 
Default letter1 [25]  | 
CHAR(6) | 
yes | 
| def_letter1_26_s | 
Default letter1 [26]  | 
CHAR(6) | 
yes | 
| def_letter1_27_s | 
Default letter1 [27]  | 
CHAR(6) | 
yes | 
| def_letter1_28_s | 
Default letter1 [28]  | 
CHAR(6) | 
yes | 
| def_letter1_29_s | 
Default letter1 [29]  | 
CHAR(6) | 
yes | 
| def_letter1_30_s | 
Default letter1 [30]  | 
CHAR(6) | 
yes | 
| def_letter1_31_s | 
Default letter1 [31]  | 
CHAR(6) | 
yes | 
| def_letter1_32_s | 
Default letter1 [32]  | 
CHAR(6) | 
yes | 
| def_letter1_33_s | 
Default letter1 [33]  | 
CHAR(6) | 
yes | 
| def_letter1_34_s | 
Default letter1 [34]  | 
CHAR(6) | 
yes | 
| def_letter1_35_s | 
Default letter1 [35]  | 
CHAR(6) | 
yes | 
| def_letter1_36_s | 
Default letter1 [36]  | 
CHAR(6) | 
yes | 
| def_letter1_37_s | 
Default letter1 [37]  | 
CHAR(6) | 
yes | 
| def_letter2_1_s | 
Default letter2 [1]  | 
CHAR(6) | 
yes | 
| def_letter2_2_s | 
Default letter2 [2]  | 
CHAR(6) | 
yes | 
| def_letter2_3_s | 
Default letter2 [3]  | 
CHAR(6) | 
yes | 
| def_letter2_4_s | 
Default letter2 [4]  | 
CHAR(6) | 
yes | 
| def_letter2_5_s | 
Default letter2 [5]  | 
CHAR(6) | 
yes | 
| def_letter2_6_s | 
Default letter2 [6]  | 
CHAR(6) | 
yes | 
| def_letter2_7_s | 
Default letter2 [7]  | 
CHAR(6) | 
yes | 
| def_letter2_8_s | 
Default letter2 [8]  | 
CHAR(6) | 
yes | 
| def_letter2_9_s | 
Default letter2 [9]  | 
CHAR(6) | 
yes | 
| def_letter2_10_s | 
Default letter2 [10]  | 
CHAR(6) | 
yes | 
| def_letter2_11_s | 
Default letter2 [11]  | 
CHAR(6) | 
yes | 
| def_letter2_12_s | 
Default letter2 [12]  | 
CHAR(6) | 
yes | 
| def_letter2_13_s | 
Default letter2 [13]  | 
CHAR(6) | 
yes | 
| def_letter2_14_s | 
Default letter2 [14]  | 
CHAR(6) | 
yes | 
| def_letter2_15_s | 
Default letter2 [15]  | 
CHAR(6) | 
yes | 
| def_letter2_16_s | 
Default letter2 [16]  | 
CHAR(6) | 
yes | 
| def_letter2_17_s | 
Default letter2 [17]  | 
CHAR(6) | 
yes | 
| def_letter2_18_s | 
Default letter2 [18]  | 
CHAR(6) | 
yes | 
| def_letter2_19_s | 
Default letter2 [19]  | 
CHAR(6) | 
yes | 
| def_letter2_20_s | 
Default letter2 [20]  | 
CHAR(6) | 
yes | 
| def_letter2_21_s | 
Default letter2 [21]  | 
CHAR(6) | 
yes | 
| def_letter2_22_s | 
Default letter2 [22]  | 
CHAR(6) | 
yes | 
| def_letter2_23_s | 
Default letter2 [23]  | 
CHAR(6) | 
yes | 
| def_letter2_24_s | 
Default letter2 [24]  | 
CHAR(6) | 
yes | 
| def_letter2_25_s | 
Default letter2 [25]  | 
CHAR(6) | 
yes | 
| def_letter2_26_s | 
Default letter2 [26]  | 
CHAR(6) | 
yes | 
| def_letter2_27_s | 
Default letter2 [27]  | 
CHAR(6) | 
yes | 
| def_letter2_28_s | 
Default letter2 [28]  | 
CHAR(6) | 
yes | 
| def_letter2_29_s | 
Default letter2 [29]  | 
CHAR(6) | 
yes | 
| def_letter2_30_s | 
Default letter2 [30]  | 
CHAR(6) | 
yes | 
| def_letter2_31_s | 
Default letter2 [31]  | 
CHAR(6) | 
yes | 
| def_letter2_32_s | 
Default letter2 [32]  | 
CHAR(6) | 
yes | 
| def_letter2_33_s | 
Default letter2 [33]  | 
CHAR(6) | 
yes | 
| def_letter2_34_s | 
Default letter2 [34]  | 
CHAR(6) | 
yes | 
| def_letter2_35_s | 
Default letter2 [35]  | 
CHAR(6) | 
yes | 
| def_letter2_36_s | 
Default letter2 [36]  | 
CHAR(6) | 
yes | 
| def_letter2_37_s | 
Default letter2 [37]  | 
CHAR(6) | 
yes | 
| def_mgr_s | 
Default manager initials for a higher credit approval  | 
CHAR(3) | 
yes | 
| def_sign_s | 
Default signature name  | 
VARCHAR2(36) | 
yes | 
| def_sign_title_s | 
Default signature title  | 
VARCHAR2(25) | 
yes | 
| ws_def_all_c | 
WS default for ALL (X/' ')  | 
CHAR(1) | 
yes | 
| ws_def_user_s | 
WS default user initials  | 
CHAR(3) | 
yes | 
| ws_def_team_s | 
WS default team  | 
CHAR(4) | 
yes | 
| ws_def_stat_s | 
WS default status  | 
CHAR(4) | 
yes | 
| ws_stat_l | 
WS sort order - status  | 
NUMBER(10) | 
yes | 
| ws_time_l | 
WS sort order - outstanding time  | 
NUMBER(10) | 
yes | 
| ws_shrt_name_l | 
WS sort order - short name  | 
NUMBER(10) | 
yes | 
| ws_number_l | 
WS sort order - application/lease number  | 
NUMBER(10) | 
yes | 
| ws_amt_l | 
WS sort order - application amount  | 
NUMBER(10) | 
yes | 
| ws_opr_l | 
WS sort order - user initials  | 
NUMBER(10) | 
yes | 
| ws_folw_l | 
WS sort order - follow-up date  | 
NUMBER(10) | 
yes | 
| ws_prior_l | 
WS sort order - note priority  | 
NUMBER(10) | 
yes | 
| perc_tolerance_d | 
Percent tolerance for exceeding credit line  | 
NUMBER(15,1) | 
yes | 
| appr_lim_d | 
Approval credit limit  | 
NUMBER(15,2) | 
yes | 
| dollar_tolerance_d | 
Dollar tolerance for exceeding credit line  | 
NUMBER(15,2) | 
yes | 
| acq_doll_tol_d | 
Acquisition cost dollar tolerance  | 
NUMBER(15,2) | 
yes | 
| acq_per_tol_d | 
Acquistion cost percent tolerance  | 
NUMBER(15,1) | 
yes | 
| doc_doll_tol_d | 
Documentation fee dollar tolerance  | 
NUMBER(15,2) | 
yes | 
| doc_per_tol_d | 
Documentation fee percent tolerance  | 
NUMBER(15,1) | 
yes | 
| down_doll_tol_d | 
Down payment dollar tolerance  | 
NUMBER(15,2) | 
yes | 
| down_per_tol_d | 
Down payment percent tolerance  | 
NUMBER(15,1) | 
yes | 
| pay_doll_tol_d | 
Payment amount dollar tolerance  | 
NUMBER(15,2) | 
yes | 
| pay_per_tol_d | 
Payment amount percent tolerance  | 
NUMBER(15,1) | 
yes | 
| res_doll_tol_d | 
Residual dollar tolerance  | 
NUMBER(15,2) | 
yes | 
| res_per_tol_d | 
Residual percent tolerance  | 
NUMBER(15,1) | 
yes | 
| sec_doll_tol_d | 
Security deposit dollar tolerance  | 
NUMBER(15,2) | 
yes | 
| sec_per_tol_d | 
Security deposit percent tolerance  | 
NUMBER(15,1) | 
yes | 
| del_doc_file_c | 
Delete document file (Y/N)  | 
CHAR(1) | 
yes | 
| override_drawdown_c | 
Override drawdown credit balance and expiration date (Y/N)  | 
CHAR(1) | 
yes | 
| email_s | 
Email address  | 
VARCHAR2(50) | 
yes | 
| fax_s | 
Fax dial number  | 
CHAR(10) | 
yes | 
| phn_s | 
Phone number  | 
CHAR(10) | 
yes | 
| def_nxt_own_to_opr_s | 
Default next owner to current operator (Y/N)  | 
VARCHAR2(37) | 
yes |