RBT_SIM_FILE

(SQL Table)
Index Back

Used for SIM import file

This is used to create file layout definition for SIM import.

# 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 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