GPMY_ORG_LINK_OPTNCO=Company
DE=Department
ET=Establishment
LO=Location
PG=Pay Group
ORG_LINK_UNITGPMY_LOC_VW(SQL View) |
Index Back |
|---|---|
GPMY_LOC_VWGPMY_LOC_VW |
| SELECT DISTINCT A.GPMY_ORG_LINK_OPTN ,B.ORG_LINK_UNIT FROM PS_GPMY_SOC_ORG_DT A ,PS_GPMY_SOC_ORG B ,PS_LOCATION_TBL C WHERE A.EFF_STATUS='A' AND A.EFFDT=B.EFFDT AND B.ORG_LINK_UNIT=C.LOCATION AND A.GPMY_ORG_LINK_OPTN='LO' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPMY_ORG_LINK_OPTN |
Character(2) | VARCHAR2(2) NOT NULL |
Organizational Link Option
CO=Company DE=Department ET=Establishment LO=Location PG=Pay Group |
| 2 | ORG_LINK_UNIT |
Character(12) | VARCHAR2(12) NOT NULL | Contains ID of an org unit to which a source bank is assigned. can be Company, Dept, Location, Pay Group or Pay Entity ID |