SCC_SFA_MSG_VW

(SQL View)
 Index Back

Message Map View


SELECT SCC_VFA_MESSAGE_ID , PROCESS_INSTANCE , EMPLID , SCC_VFA_SEQ_ID , INSTITUTION , SCC_VOC_MSG_SEQ , SCC_VFA_MESSAGE_CL , SCC_SFP_RESPSTAT , DESCRLONG , SCC_SFP_REASON , SCC_SFP_TRANS_STAT , SCC_ROW_ADD_OPRID , SCC_ROW_ADD_DTTM , SCC_ROW_UPD_OPRID , SCC_ROW_UPD_DTTM FROM PS_SCC_SFA_MSG_MAP

# 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 DESCRLONG Long Character CLOB Long Description
10 SCC_SFP_REASON Long Character CLOB Reason
11 SCC_SFP_TRANS_STAT Character(1) VARCHAR2(1) NOT NULL SFP Transaction Status
E=Error
S=Success
W=Warning
12 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
13 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
14 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
15 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time