SFA_BALIDQ_VW_I

(SQL View)
Index Back

Interface View -BALANCE_ID_QTR

Campus Solutions - Work Earnings interface view for Payroll record BALANCE_ID_QTR.

SELECT SETID , BALANCE_ID , BALANCE_YEAR , BALANCE_QTR , PERIOD_NAME , PERIOD_ABBRV , DETL_PERIOD_FROM , DETL_PERIOD_TO FROM PS_BALANCE_ID_QTR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID
3 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year
4 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter
5 PERIOD_NAME Character(30) VARCHAR2(30) NOT NULL Period Name
6 PERIOD_ABBRV Character(3) VARCHAR2(3) NOT NULL Abbreviation
7 DETL_PERIOD_FROM Number(3,0) SMALLINT NOT NULL Detail Calendar From Period
8 DETL_PERIOD_TO Number(3,0) SMALLINT NOT NULL Detail Calendar To Period