GP_CC_VW(SQL View) | 
Index Back | 
|---|---|
GP Cost Center Chartf. ViewView 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 | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity | |
| 2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 3 | Date(10) | DATE NOT NULL | 
Effective Date
 Default Value: %date  |