RS_WC_SO_EXCEP1(SQL View) |
Index Back |
|---|---|
SOs with Inactive Coordinator |
| SELECT A.BUSINESS_UNIT ,A.SO_ID ,A.DESCR60 ,A.SO_STATUS ,A.ASSIGNED_TO ,J.EMPLID FROM PS_RS_SOSTAT_VW A ,PS_ROLEXLATOPR B ,PS_JOB J WHERE A.ASSIGNED_TO = B.OPRID AND A.SO_STATUS IN ('N','O','I') AND B.EMPLID=J.EMPLID AND J.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J.EMPLID = J1.EMPLID AND J.EMPL_RCD = J1.EMPL_RCD AND J1.EFFDT <= %CurrentDateIn) AND J.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J.EMPLID = J2.EMPLID AND J.EMPL_RCD = J2.EMPL_RCD AND J.EFFDT = J2.EFFDT) AND J.EMPL_STATUS IN ('I', 'T', 'S', 'D', 'U', 'V', 'R', 'Q', 'X') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 4 | SO_WC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Service Order Status for Work Center
C=Closed D=Draft I=In Process N=New O=Open X=Canceled |
| 5 | ASSIGNED_TO | Character(30) | VARCHAR2(30) NOT NULL | Assigned To |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |