GPDE_AL_PELO_VW(SQL View) |
Index Back |
---|---|
Pay Entity LocationsPay Entity Locations |
SELECT DISTINCT PAY_ENTITY , EFFDT FROM PS_GPDE_AL_PE_LOC |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |