SCC_SFP_R_SAP(SQL Table) |
Index Back |
---|---|
SFP SAP Academic InformationThis record is used to track SAP Academic information. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
|
2 | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution | |
3 | Number(15,0) | DECIMAL(15) NOT NULL | Vocado message sequence number | |
4 | Number(4,0) | SMALLINT NOT NULL | Academic Year Number | |
5 | Number(4,0) | SMALLINT NOT NULL | Period Number | |
6 | Number(4,0) | SMALLINT NOT NULL | Sap Seq for SFP | |
7 | SCC_SFP_SAP_STAT | Character(30) | VARCHAR2(30) NOT NULL | SAp Status for SFP |
8 | SCC_SFP_SAP_MTF_ST | Character(30) | VARCHAR2(30) NOT NULL | MTF Status for SFP |
9 | SCC_SFP_SAP_MTF_VA | Number(9,3) | DECIMAL(8,3) NOT NULL | MTF value for SFP |
10 | SCC_SFP_SAP_PACE_S | Character(30) | VARCHAR2(30) NOT NULL | Pace Status for SFP |
11 | SCC_SFP_SAP_PACE_V | Number(9,3) | DECIMAL(8,3) NOT NULL | Pace Value for SFP |
12 | SCC_SFP_SAP_GPA_ST | Character(30) | VARCHAR2(30) NOT NULL | GPA Status for SFP |
13 | SCC_SFP_SAP_GPA | Number(9,3) | DECIMAL(8,3) NOT NULL | GPA for SFP |
14 | SCC_SFP_SAP_EVA_DT | Date(10) | DATE | Eva date for SFP |
15 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
16 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
17 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
18 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |