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 |