SCC_SFP_R_DISB

(SQL Table)
Index Back

SFP Disb Event Disbursement

SFP Disbursement Event Disbursement Node

# 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_FUND_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_PERIOD_SEQ Number(4,0) SMALLINT NOT NULL Period Number
7 SCC_SFP_PAY_P_SEQ Number(4,0) SMALLINT NOT NULL Pay Period Number
8 SCC_SFP_DISB_SEQ Number(4,0) SMALLINT NOT NULL Disbursement Number
9 SCC_SFP_AWARD_YEAR Character(12) VARCHAR2(12) NOT NULL Award Year
10 SCC_SFP_DISB_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Disbursed Amount
11 SCC_SFP_DIBSNETAMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Net Disbursement Amount
12 SCC_SFP_INTREBAMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Interest Rebate Amount
13 SCC_SFP_DIBSFEEAMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Disbursement Fee Amount
14 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
15 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
16 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
17 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time