S_NC_IMM_System_Codes (ver 13.6.0)
This table is a stand alone table and stores IMM codes.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Active | 13.6.0 | NUMBER(1,0) | Indicates if this code is active or not. |
Alt_Desc | 13.6.0 | VARCHAR2(255) | Indicates the alternate description of the code. |
Area | 13.6.0 | VARCHAR2(30) | Indicates the area for this code. |
Code | 13.6.0 | VARCHAR2(5) | The immigrant code. |
| Code_Type | 13.6.0 | VARCHAR2(5) | Indicates the type of immigrant code. |
Description | 13.6.0 | VARCHAR2(255) | The description of the code. |
| ID | 13.6.0 | NUMBER(19,0) | Primary key |
Sort_Order | 13.6.0 | NUMBER(11,0) | Indicates the sort order for this code. |
WhatCreated | 13.6.0 | VARCHAR2(50) | Indicates the process that created this record. |
WhatModified | 13.6.0 | VARCHAR2(50) | Indicates the process that modified this record. |