SID_MSGPrompt Table: EX_TWILIO_EE_VW
A=Text Message Not Allow
D=Duplicate Employee
I=Invalid for Expenses
N=Employee Not Found
Y/N Table Edit
A=Active
I=Inactive
EX_TWILIO_ERR(SQL Table) |
Index Back |
|---|---|
Text Message Error |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SID_MSG |
Character(50) | VARCHAR2(50) NOT NULL | Message Sid |
| 2 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | TW_PHONE_NBR | Character(17) | VARCHAR2(17) NOT NULL | Twilio Phone Number |
| 4 | EMP_PHONE_NBR | Character(17) | VARCHAR2(17) NOT NULL | Phone Number |
| 5 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date and time |
| 6 | MSG_BODY | Character(254) | VARCHAR2(254) NOT NULL | Message Body |
| 7 | NUM_MEDIA | Number(2,0) | SMALLINT NOT NULL | Media Number |
| 8 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: EX_TWILIO_EE_VW |
| 9 | EMPLID_FROM | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 10 | TW_ERR_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Twilio Error Code
A=Text Message Not Allow D=Duplicate Employee I=Invalid for Expenses N=Employee Not Found |
| 11 | RELOAD_PROC | Character(1) | VARCHAR2(1) NOT NULL |
Reload Process
Y/N Table Edit |
| 12 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |