RBT_ICCIDN=Exclude Prepaid
Y=Include Prepaid
Y/N Table Edit
Default Value: N
RBT_SIM_IMP(SQL Table) |
Index Back |
|---|---|
SIM header tableThis table is used to track SIM card information for Wireless services. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBT_ICCID |
Character(20) | VARCHAR2(20) NOT NULL | Integrated Circuit Card ID. |
| 2 | RBT_IMSI | Character(15) | VARCHAR2(15) NOT NULL | International Mobile Subscriber Identity. |
| 3 | RBT_PIN1 | Character(15) | VARCHAR2(15) NOT NULL | PIN number |
| 4 | RBT_PIN2 | Character(15) | VARCHAR2(15) NOT NULL | PIN number |
| 5 | RBT_PUK1 | Character(15) | VARCHAR2(15) NOT NULL | PUK Code |
| 6 | RBT_PUK2 | Character(15) | VARCHAR2(15) NOT NULL | PUK Code |
| 7 | PREPAID_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Prepaid offering
N=Exclude Prepaid Y=Include Prepaid |
| 8 | RBT_PROV_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate pre-provisioned SIMs.
Y/N Table Edit Default Value: N |
| 9 | RBT_AREA_CODEV | Character(15) | VARCHAR2(15) NOT NULL | Telephone area code for use in number management |
| 10 | RBTVOICENUM | Character(15) | VARCHAR2(15) NOT NULL | Number For Telco |
| 11 | RBT_AREA_CODEF | Character(15) | VARCHAR2(15) NOT NULL | Telephone area code for use in number management |
| 12 | RBTFAXNUM | Character(15) | VARCHAR2(15) NOT NULL | Number For Telco |
| 13 | RBT_AREA_CODED | Character(15) | VARCHAR2(15) NOT NULL | Telephone area code for use in number management |
| 14 | RBTDATANUM | Character(15) | VARCHAR2(15) NOT NULL | Number For Telco |
| 15 | ACTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Action ID |