GP_BAL_SS

(SQL Table)
Index Back

SS Absence Balances Definition

Self Service Absence Balances Definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 PIN_ENTL_BAL_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_AE0_VW

3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Days
H=Hours
5 STORE_RSLT_IF_ZERO Character(1) VARCHAR2(1) NOT NULL Store Results if Zero
N=If Element Or Comp Is Non-Zero
X=If Element Is Non-Zero
Y=Always Store