SCC_SFP_R_DOCVW

(SQL View)
 Index Back

SFP Document Data Status View

This view references the table that tracks the document data from the SFP Vocado FasDocumentProcessStatusInformationEvent event.

SELECT EMPLID , INSTITUTION , SCC_VOC_MSG_SEQ , SCC_SFP_PROC_SEQ , SCC_SFP_DOC_SEQ , SCC_SFP_DOC_SEQ_SU , SCC_SFP_DOC_OWNER , SCC_SFP_DOC_CODE , SCC_SFP_DOC_NAME , SCC_SFP_DOC_STAT , SCC_SFP_DOC_STATDT , SCC_SFP_DOC_RCDTTM , SCC_SFP_AWARD_YEAR , SCC_SFP_DOC_EXT_ID , SCC_SFP_DOC_RATION , SCC_SFP_DOC_REQMSG , SCC_SFP_DOC_DAYS , SCC_SFP_DOC_REQDT ,SCC_ROW_ADD_OPRID ,SCC_ROW_ADD_DTTM ,SCC_ROW_UPD_OPRID ,SCC_ROW_UPD_DTTM FROM PS_SCC_SFP_R_DOC WHERE SCC_SFP_DOC_SEQ_SU =0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 SCC_VOC_MSG_SEQ Number(15,0) DECIMAL(15) NOT NULL Vocado message sequence number
4 SCC_SFP_PROC_SEQ Number(3,0) SMALLINT NOT NULL NSLDS Request File sequence number (up to 99 per given submittal date).
5 SCC_SFP_DOC_SEQ Number(3,0) SMALLINT NOT NULL NSLDS Request File sequence number (up to 99 per given submittal date).
6 SCC_SFP_DOC_SEQ_S2 Number(3,0) SMALLINT NOT NULL NSLDS Request File sequence number (up to 99 per given submittal date).

Default Value: 0

7 SCC_SFP_DOC_OWNER Character(20) VARCHAR2(20) NOT NULL Document Owner Type
8 SCC_SFP_DOC_CODE Character(50) VARCHAR2(50) NOT NULL Document Code
9 SCC_SFP_DOC_NAME Character(50) VARCHAR2(50) NOT NULL Document Name
10 SCC_SFP_DOC_STAT Character(20) VARCHAR2(20) NOT NULL Document Status
11 SCC_SFP_DOC_STATDT Date(10) DATE Document Status Date
12 SCC_SFP_DOC_RCDTTM DateTime(26) TIMESTAMP Document Received Datetime
13 SCC_SFP_AWARD_YEAR Character(12) VARCHAR2(12) NOT NULL Award Year
14 SCC_SFP_DOC_EXT_ID Character(20) VARCHAR2(20) NOT NULL External Document Id
15 SCC_SFP_DOC_RATION Character(20) VARCHAR2(20) NOT NULL Document Rationale
16 SCC_SFP_DOC_REQMSG Long Character CLOB Document Request Message
17 SCC_SFP_DOC_DAYS Number(4,0) SMALLINT NOT NULL Days Since Original Doc Reques
18 SCC_SFP_DOC_REQDT Date(10) DATE Document Request Date
19 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
20 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
21 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
22 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time