RC_WKR_LCTN_VW(SQL View) |
Index Back |
---|---|
Location for a WorkerThis view is used in the worker 360 to display the location |
SELECT A.BO_ID , A.PERSON_ID , B.SETID_LOCATION , B.LOCATION ,C.DESCR FROM PS_RD_PERSON A , PS_RB_WORKER_ALL B , PS_LOCATION_TBL C WHERE B.PERSON_ID = A.PERSON_ID AND C.SETID = B.SETID_LOCATION AND C.LOCATION = B.LOCATION AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_LOCATION_TBL C1 WHERE C1.SETID = C.SETID AND C1.LOCATION = C.LOCATION AND C1.EFFDT <= %CurrentDateIn AND C1.EFF_STATUS = 'A') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
2 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
3 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
4 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |