GP_CC_VW

(SQL View)
Index Back

GP Cost Center Chartf. View

View on GP Chartfield configuration for Cost Center

SELECT DISTINCT PAY_ENTITY , BUSINESS_UNIT , EFFDT FROM PS_GP_CC_SET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date