SESSION_IDEMPLIDRS_CW_EMPL_RCDY/N Table Edit
Default Value: Y
E=Employee
N=Non-Employee
Prompt Table:
PROJ_ROLE
Set Control Field: BUSINESS_UNIT
Prompt Table: RS_POOL_ACTIVE
Prompt Table: RS_REGION
RS_CW_SLCT_TMP(SQL Table) |
Index Back |
|---|---|
Create ResourcesSUJ--Inluded field RS_CW_SELECTED as check box |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SESSION_ID |
Number(6,0) | INTEGER NOT NULL | Session ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | RS_CW_EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | SMALLINT NOT NULL |
| 4 | RS_CW_SELECTED | Character(1) | VARCHAR2(1) NOT NULL |
VARCHAR2(1) NOT NULL
Y/N Table Edit Default Value: Y |
| 5 | PERSON_NAME | Character(100) | VARCHAR2(100) NOT NULL | Name |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 10 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
| 11 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
PROJ_ROLE
|
| 12 | POOL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Pool ID field.
Prompt Table: RS_POOL_ACTIVE |
| 13 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: RS_REGION |