| Description | Column | Datatype |
|---|---|---|
| Name code
02 - Company 03 - Region 04 - Office 06 - County 07 - City 08 - Salesperson 09 - Credit approval officer 09 - Funding approval officer 09 - Document approval officer 10 - Financial institution 14 - Portfolio 15 - Tax Entity |
rnm_flg_s | char (2) |
| Name key
Company - port(2)/comp(2)/blank(5) Region - port(2)/comp(2)/region(2)/blank(3) Office - port(2)/comp(2)/region(2)/office(3) County/City - location code(4)/blank(5) Salesperson - salesperson(4)/blank(5) Lending officer - lending officer(9) Financial institution - financial institution(4)/blank(5) Portfolio - port(2)/blank(7) Tax entity - tax entity(4)/blank(5) |
rnm_key_s | char (9) |
| Sybase timestamp | timestamp | timestamp |
| Name | nam_s | char (36) |
| Default application | def_app_s | char (10) |
| Portfolio or state | por_st_s | char (2) |
| Company | com_s | char (2) |
| Region | reg_s | char (2) |
| Office | off_s | char (3) |
| Name code - officer
Only applicable for credit, funding or document approval records. |
officer_s | char (9) |
| Name codes
Only applicable for financial institution, CCA tax entity or salesperson records. |
dnm_code_s | char (4) |
| Collection team | col_team_s | char (4) |
| Collateral team | kol_team_s | char (4) |
| Maturing lease team | ml_team_s | char (4) |
| CCA default tax entity
Only applicable for company, region, and office or CCA default portfolio for tax entity (only the first 2 bytes are used) |
def_ent_s | char (4) |
| Company code | com_code_s | char (4) |
| Cost center | cost_ctr_s | char (4) |
| Group code | grp_code_s | char (2) |
| Insurance team | ins_team_s | char (4) |
| Index name | Piece 1 | Piece 2 | Piece 3 |
|---|---|---|---|
| rnm_idx0 | rnm_flg_s | rnm_key_s | |
| rnm_idx1 | nam_s | rnm_flg_s | rnm_key_s |