SCC_SFA_MSG_MAP

(SQL Table)
Index Back

Message Map

Map 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