SSF_CAN_ERN_BAL

(SQL View)
 Index Back

SSF CAN Earnings Balance

Student Financials Product View of Payroll - North America record CAN_ERN_BALANCE. View is used by SF to interface with PNA data for Canadian Earnings Balances.

SELECT EMPLID , COMPANY , BALANCE_ID , BALANCE_YEAR , WAGE_LOSS_PLAN , PROVINCE , EMPL_RCD , BALANCE_QTR , BALANCE_PERIOD , SPCL_BALANCE , ERNCD , HRS_YTD , HRS_QTD , HRS_MTD , GRS_YTD , GRS_QTD , GRS_MTD FROM PS_CAN_ERN_BALANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: HCR_PERSON_I

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: HCR_COMPANY_I

3 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID

Prompt Table: SSF_BAL_ID_TBL

4 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year

Prompt Table: SSF_BAL_ID_DEF

5 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan

Prompt Table: SSF_WAGELS_PLN

6 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
7 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
8 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter

Prompt Table: SSF_BAL_ID_QTR

9 BALANCE_PERIOD Number(3,0) SMALLINT NOT NULL Balances for Period

Prompt Table: SSF_BAL_ID_DEF

10 SPCL_BALANCE Character(1) VARCHAR2(1) NOT NULL Spl Accumulator Bal/Earn Code

Y/N Table Edit

11 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

Prompt Table: SSF_EARN_CD_VW

12 HRS_YTD Signed Number(8,2) DECIMAL(6,2) NOT NULL Hours YTD
13 HRS_QTD Signed Number(8,2) DECIMAL(6,2) NOT NULL Hours QTD
14 HRS_MTD Signed Number(8,2) DECIMAL(6,2) NOT NULL Hours Mtd
15 GRS_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Gross Earnings YTD
16 GRS_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Gross Earnings QTD
17 GRS_MTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Gross Earnings MTD