SCC_SFP_R_DOC

(SQL Table)
Index Back

SFP Document Data Status

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

# 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_SU Number(3,0) SMALLINT NOT NULL NSLDS Request File sequence number (up to 99 per given submittal date).
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_DAYS Number(4,0) SMALLINT NOT NULL Days Since Original Doc Reques
17 SCC_SFP_DOC_REQDT Date(10) DATE Document Request Date
18 SCC_SFP_DOC_REQMSG Long Character CLOB Document Request Message
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