Specifies the columns and rows with Oracle data type information for the rru
Recovery User Profile table.
Description | Column Name | Data Type ? | Characteristics ? |
---|---|---|---|
Operator initials | opr_s | char | length 3 |
Record modification stamp | stamp_l | number | precision 10 |
Display newer follow-up dates before old dates (Y/N) | s_new_note_first_c | char | length 1 |
Display accounts legal to call only (Y/N) | call_c | char | length 1 |
Supervisor (Y/N) | supervisor_c | char | length 1 |
Bankruptcy (Y/N) | bankruptcy_c | char | length 1 |
Access all recovery accounts (Y/N) | all_rec_c | char | length 1 |
User has access to corresponding recovery menu option (Y/N) | s_rec_mod_c | varchar2 | length 30 |
WS default for ALL (X/' ') | ws_def_all_c | char | length 1 |
WS default team | ws_def_team_s | char | length 4 |
WS default user initials | ws_def_user_s | char | length 3 |
WS default queue number | ws_def_queue_s | char | length 4 |
WS sort order - collection status | ws_col_stat_l | number | precision 10 |
WS sort order - short name | ws_shrt_name_l | number | precision 10 |
WS sort order - lease number | ws_lse_num_l | number | precision 10 |
WS sort order - application amount | ws_amt_l | number | precision 10 |
WS sort order - follow-up date | ws_folw_l | number | precision 10 |
WS sort order - note priority | ws_prior_l | number | precision 10 |
WS sort order weight | ws_weight_l | number | precision 10 |
XSL file name | xsl_filename_s | varchar2 | length 25 |
Email address | email_s | varchar2 | length 50 |
Fax dial number | fax_s | char | length 10 |
Phone number | phn_s | char | length 10 |
Index Name | Piece 1 |
---|---|
rru_idx0 | opr_s |
Following are descriptions of the Oracle data types used in the LeasePak database. Note that LeasePak does not use all the Oracle data types.
LeasePak 6.0a Documentation Suite
©
2008 by McCue Systems Incorporated. All rights reserved.
The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.