RB_SMS_MSG_IDF=Fail set Upt-out
H=Help
I=Opt-in
O=Opt-out
U=Unknow
Default Value: DONE
RB_SMS_MO(SQL Table) |
Index Back |
|---|---|
SMS MOShort Text Message tranx for MO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RB_SMS_MSG_ID |
Character(32) | VARCHAR2(32) NOT NULL | It is the SMS provider gateway returned message ID. |
| 2 | RB_SMS_SHORT_CODE | Character(10) | VARCHAR2(10) NOT NULL | Use for the SMS short code |
| 3 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 4 | ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 5 | BO_REL_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Relationship ID of a Business Object |
| 6 | CELL_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Cell Phone |
| 7 | RB_SMS_MSG_CONTENT | Character(160) | VARCHAR2(160) NOT NULL | Short Text Message content |
| 8 | RB_SMS_NETWORK_ID | Character(32) | VARCHAR2(32) NOT NULL | It is the SMS provider gateway returned message ID. |
| 9 | RB_SMS_MO_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Track MO status-
F=Fail set Upt-out H=Help I=Opt-in O=Opt-out U=Unknow Default Value: DONE |
| 10 | SENT_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |