BALANCES_VW

(SQL View)
 Index Back

Pay Calendar - Balance ID View

Used in the pay calendar to display appropriate balance ID information.

SELECT DISTINCT a.setid , a.balance_id , b.balance_year , b.balance_period , c.balance_qtr , b.begin_dt , b.end_dt , c.detl_period_from , c.detl_period_to , a.descrshort FROM ps_balance_id_tbl a ,PS_BALANCE_ID_DEF b ,ps_balance_id_qtr c WHERE (a.setid = b.setid AND b.setid = c.setid) AND (a.balance_id=b.balance_id AND b.balance_id=c.balance_id) AND b.balance_year = c.balance_year AND (c.detl_period_from<=b.balance_period AND c.detl_period_to>=b.balance_period)

  • Related Language Record: BALANCES_LNG_VW

  • Parent record: BALANCE_ID_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID
    3 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year

    Prompt Table: BALANCE_YR_VW

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

    Prompt Table: BALANCE_ID_DEF

    5 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter

    Prompt Table: BALANCE_ID_QTR

    6 BEGIN_DT Date(10) DATE Begin Date
    7 END_DT Date(10) DATE end date
    8 DETL_PERIOD_FROM Number(3,0) SMALLINT NOT NULL Detail Calendar From Period
    9 DETL_PERIOD_TO Number(3,0) SMALLINT NOT NULL Detail Calendar To Period
    10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description