RBT_SIM_FILE(SQL Table) |
Index Back |
|---|---|
Used for SIM import fileThis is used to create file layout definition for SIM import. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 | RBTFAXNUM | Character(15) | VARCHAR2(15) NOT NULL | Number For Telco |
| 10 | RBTDATANUM | Character(15) | VARCHAR2(15) NOT NULL | Number For Telco |
| 11 | RBTVOICENUM | Character(15) | VARCHAR2(15) NOT NULL | Number For Telco |