RS_ASSGN_HDR_VW(SQL View) |
Index Back |
|---|---|
Assignment Header viewThis view holds the assignment header related data used in fluid approval |
| SELECT A.ASSIGNMENT_ID ,A.DESCR ,A.PROJ_ROLE ,J.DESCR ,A.EMPLID ,P.NAME ,P.PER_STATUS ,B.DEPTID ,D.DESCR ,P1.NAME AS MANAGER_NAME ,E.ASSIGN_STS ,A.TASK_TYPE ,K.DESCR AS CATEGORY ,A.ASSIGNED_TO ,F.NAME ,A.BUSINESS_UNIT ,A.PROJECT_ID ,G.DESCR ,A.CUST_ID ,'' ,A.ADDRESS_SEQ_NUM ,'' ,A.CNTCT_SEQ_NUM ,'' FROM PS_RS_ASSIGNMENT A , PS_PERSONAL_DATA P ,PS_PERSONAL_DATA P1 ,PS_RS_WO_CURJOB_VW B ,PS_RS_EMPL_SPVR_VW C , PS_DEPT_TBL D , PS_RS_ASSGN_STS E , PS_RS_OPR_NAME_VW F , PS_SP_PROJ_NONVW G , PS_RS_PROJROLE_VW J , PS_RS_ASSGN_TTVW K , PS_SET_CNTRL_REC AC1 , PS_SET_CNTRL_REC AC2 WHERE P.EMPLID = A.EMPLID AND B.EMPLID = A.EMPLID AND C.EMPLID = A.EMPLID AND C.SUPERVISOR_ID = P1.EMPLID AND E.ASSIGNMENT_ID = A.ASSIGNMENT_ID AND E.LASTUPDDTTM = ( SELECT MAX(E1.LASTUPDDTTM) FROM PS_RS_ASSGN_STS E1 WHERE E1.ASSIGNMENT_ID= E.ASSIGNMENT_ID) AND F.OPRID = A.ASSIGNED_TO AND G.BUSINESS_UNIT = A.BUSINESS_UNIT AND G.PROJECT_ID = A.PROJECT_ID AND AC2.SETCNTRLVALUE = A.BUSINESS_UNIT AND AC2.RECNAME = 'PROJ_ROLE' AND J.SETID = AC2.SETID AND J.PROJ_ROLE = A.PROJ_ROLE AND AC1.SETCNTRLVALUE = A.BUSINESS_UNIT AND AC1.RECNAME = 'DEPT_TBL' AND D.SETID = AC1.SETID AND D.DEPTID = B.DEPTID AND K.TASK_TYPE = A.TASK_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ASSIGNMENT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Work Assignment ID
Default Value: NEXT |
| 2 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table: RS_PROJROLE_VW |
| 4 | DESCR4 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: RS_WRKR_ADD_VW |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 7 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | MANAGER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Identifies the name of the manager of a specified department. |
| 11 | ASSIGN_STS | Character(2) | VARCHAR2(2) NOT NULL |
Assignment Status
A=Assign C=Complete I=Interview P=Propose R=Reject S=Reserve V=Pending Approval X=Cancel |
| 12 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Task Category |
| 13 | DESCR_2 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 14 | ASSIGNED_TO | Character(30) | VARCHAR2(30) NOT NULL |
Assigned To
Prompt Table: RS_OPR_NAME_VW1 |
| 15 | NAME50 | Character(50) | VARCHAR2(50) NOT NULL | name field of length 50 |
| 16 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 17 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: %EDITTABLE5 |
| 18 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 19 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: RS_CUSTOMER_VW |
| 20 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 21 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Address Sequence Number
Prompt Table: %EDITTABLE7 |
| 22 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 23 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Contact Sequence Number
Prompt Table: CUST_CONTACT |
| 24 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |