EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONSCC_VOC_MSG_SEQSCC_SFP_PROG_SEQSCC_SFP_YEAR_SEQSCC_SFP_FUND_SEQSCC_SFP_PAY_P_SEQSCC_SFP_PERIOD_SEQSCC_SFP_R_APP(SQL Table) |
Index Back |
|---|---|
SFP FPO V2 Award Pay PeriodThis record is used to store award payment period data from the SFP FPO v2 event. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 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_PROG_SEQ |
Number(4,0) | SMALLINT NOT NULL | Sequence |
| 5 | SCC_SFP_YEAR_SEQ |
Number(4,0) | SMALLINT NOT NULL | Academic Year Number |
| 6 | SCC_SFP_FUND_SEQ |
Number(4,0) | SMALLINT NOT NULL | Sequence |
| 7 | SCC_SFP_PAY_P_SEQ |
Number(4,0) | SMALLINT NOT NULL | Pay Period Number |
| 8 | SCC_SFP_PERIOD_SEQ |
Number(4,0) | SMALLINT NOT NULL | Period Number |
| 9 | SCC_SFP_AWARD_YEAR | Character(12) | VARCHAR2(12) NOT NULL | Award Year |
| 10 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 11 | SCC_SFP_PAY_P_STAT | Character(10) | VARCHAR2(10) NOT NULL | Payment Period Status |
| 12 | SCC_SFP_PAY_P_F_ST | Character(10) | VARCHAR2(10) NOT NULL | Payment Period Fund Status |
| 13 | SCC_SFP_PAY_P_F_AC | Character(10) | VARCHAR2(10) NOT NULL | Fund Acceptance Status |
| 14 | SCC_SFP_FUND_ACCPT | Character(1) | VARCHAR2(1) NOT NULL | Fund Acceptance Required |
| 15 | SCC_SFP_DISB_HOLD | Character(1) | VARCHAR2(1) NOT NULL | Disbursement Hold Indicator |
| 16 | SCC_SFP_MAX_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Fund Max Amount |
| 17 | SCC_SFP_AWARD_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Fund Award Amount |
| 18 | SCC_SFP_ACCEPT_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Accepted Amount |
| 19 | SCC_SFP_DISB_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Disbursed Amount |
| 20 | SCC_SFP_DISBNETAMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Net Disbursement Amount |
| 21 | SCC_SFP_GRADE_LVL | Number(2,0) | SMALLINT NOT NULL | Grade Level |
| 22 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 23 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 24 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 25 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 26 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |