SFA_CR_DOCUMENT_IDI=XML Processed
L=Outbound to Stage
P=Generated XML
S=Ready to generate XML
X=XML Loaded to Stage
1.0A=Version 1.0a
Default Value: 1.0A
SFA_FWS_DOCUMNT(SQL Table) |
Index Back |
|---|---|
COD FWS Document InformationParent Table to all other Federal Work Study record. Contains general information about the COD FWS document. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFA_CR_DOCUMENT_ID |
Character(34) | VARCHAR2(34) NOT NULL | Document ID |
| 2 | SFA_CR_CREATE_DTTM | Character(22) | VARCHAR2(22) NOT NULL | Created Date & Time |
| 3 | SFA_CR_SRC_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Source Type |
| 4 | SFA_CR_SRC_ID | Character(8) | VARCHAR2(8) NOT NULL | Source ID |
| 5 | SFA_CR_DEST_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Destination Type |
| 6 | SFA_CR_DEST_ID | Character(8) | VARCHAR2(8) NOT NULL | Destination ID |
| 7 | SFA_CR_SFTWARE_PRO | Character(10) | VARCHAR2(10) NOT NULL | Software Provider |
| 8 | SFA_CR_SFTWARE_VER | Character(6) | VARCHAR2(6) NOT NULL | Software Version |
| 9 | SFA_CR_FULL_RSP_CD | Character(8) | VARCHAR2(8) NOT NULL | Full Response Flag |
| 10 | SFA_CR_RECEIPT | Character(22) | VARCHAR2(22) NOT NULL | Receipt Date |
| 11 | SFA_CR_DOC_TYPE | Character(35) | VARCHAR2(35) NOT NULL | Document Type |
| 12 | SFA_CR_DOC_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Document Status |
| 13 | SFA_CR_PROCESS_DT | Character(10) | VARCHAR2(10) NOT NULL | Process Date |
| 14 | SFA_CR_PS_PRC_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Processing Status
I=XML Processed L=Outbound to Stage P=Generated XML S=Ready to generate XML X=XML Loaded to Stage |
| 15 | SFA_CR_PS_IN_DTTM | DateTime(26) | TIMESTAMP | Inbound DateTime |
| 16 | SFA_CR_PS_OUT_DTTM | DateTime(26) | TIMESTAMP | Outbound DateTime |
| 17 | SFA_FWS_SCHEMA_VER | Character(4) | VARCHAR2(4) NOT NULL |
Campus Based Schema Version
1.0A=Version 1.0a Default Value: 1.0A |
| 18 | SFA_FILE_PATH_NAME | Character(128) | VARCHAR2(128) NOT NULL | File Path and Name |
| 19 | SFA_CR_OTHSFT_PRO | Character(10) | VARCHAR2(10) NOT NULL | Other Software Provider |
| 20 | SFA_CR_OTHSFT_VER | Character(6) | VARCHAR2(6) NOT NULL | Other Software Version |