SCC_SFA_MSG_MAP(SQL Table) |
Index Back |
---|---|
Message MapMap uuid message id to a particular transaction |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCC_VFA_MESSAGE_ID | Character(36) | VARCHAR2(36) NOT NULL | Message Id |
2 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | SCC_VFA_SEQ_ID | Character(36) | VARCHAR2(36) NOT NULL | Id |
5 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
6 | SCC_VOC_MSG_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Vocado message sequence number |
7 | SCC_VFA_MESSAGE_CL | Character(4) | VARCHAR2(4) NOT NULL |
Student Financial Planning Message Class
AAID=Anticipated Aid DCAN=Cancel Disbursement DISB=Disbursement Information DOC=Document Process Status DSB2=Disbursement Reporting ISIR=ISIR META=Document Metadata MIME=Multipart Message MVAL=Message Validation Error NSLD=NSLDS NTF=Notification PACK=Packaging Start Date PLUS=Plus Refund RTLN=Return To Lender SAFI=Student Academic and Fin Info SAP=Satisfactory Academic Progress SGRP=Student Groups STIN=Student Initiation STLA=Student Leave of Absence STUP=Student Update T4DN=Title IV Data Needed UNSP=Unsupported Default Value: UNSP |
8 | SCC_SFP_RESPSTAT | Number(4,0) | SMALLINT NOT NULL | Response Status |
9 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
10 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
11 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
12 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |
13 | DESCRLONG | Long Character | CLOB | Long Description |
14 | SCC_SFP_REASON | Long Character | CLOB | Reason |
15 | SCC_SFP_TRANS_STAT | Character(1) | VARCHAR2(1) NOT NULL |
SFP Transaction Status
E=Error S=Success W=Warning |