EMPLIDSTAFF_IDN=No
Y=Yes
A=Active
I=Inactive
S=Staff
U=Unit
V=Volunteer
AV_ASGN_INQ_WRK(SQL View) |
Index Back |
|---|---|
Resource Assignments Work VwThis view is used on the resource assignments panel as a work scroll. It is defined as a view so that the panel processor will allow data to be read into the grid scroll. This view should never be used to retrieve data, and any scroll using it should be set to NO AUTO SELECT, with data being brought back by a SCROLL SELECT from another record into it. |
| SELECT A.EMPLID , A.EMPLID , A.EMPLID , A.STAFF_ID , 'DESCR2' , A.PURPOSE_CD , 'N' , A.START_DT , A.END_DT , A.SPOUSE_LINK , A.INSTITUTION , 'A' , 'S' , 'U' , A.INTV_CD FROM PS_AV_ASGN_STF_PRP A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 3 | RSRC_ASGN_PRSP | Character(30) | VARCHAR2(30) NOT NULL | Assigned Prospect |
| 4 | STAFF_ID |
Character(11) | VARCHAR2(11) NOT NULL | Staff ID |
| 5 | RSRC_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Resource Name |
| 6 | PURPOSE_CD | Character(3) | VARCHAR2(3) NOT NULL | Role |
| 7 | WORKSET_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Select Y/N
N=No Y=Yes |
| 8 | START_DT | Date(10) | DATE | Start Date |
| 9 | END_DT | Date(10) | DATE | end date |
| 10 | SPOUSE_LINK | Character(1) | VARCHAR2(1) NOT NULL | Spouse Link |
| 11 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 12 | PRSP_ASGN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Active
A=Active I=Inactive |
| 13 | ASGNMNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Assignment Type
S=Staff U=Unit V=Volunteer |
| 14 | UNIT_CD | Character(11) | VARCHAR2(11) NOT NULL | Unit Code |
| 15 | INTV_CD | Character(10) | VARCHAR2(10) NOT NULL | Initiative Code |