RS_GRR_TEAM_WB(SQL Table) |
Index Back |
|---|---|
Pool Manager Work TablePool Manager Work Table for Resource Scroll |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 3 | GRR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Generic Resource Request ID.
Default Value: NEXT |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: RS_WORKER_TBL |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | FIT_DISPLAY_AVA | Character(15) | VARCHAR2(15) NOT NULL | Display availability fitness score. |
| 7 | FIT_DISPLAY_QUA | Character(15) | VARCHAR2(15) NOT NULL | Display qualification fitness score. |
| 8 | IMAGE_1 | Character(30) | VARCHAR2(30) NOT NULL | Default Image Name |
| 9 | 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 Prompt Table: RS_ASSGN_ST_TBL |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | ASSIGNMENT_PB | Character(1) | VARCHAR2(1) NOT NULL | Assignment |
| 14 | RS_CALENDAR | Character(1) | VARCHAR2(1) NOT NULL | Calendar field. |
| 15 | PROJECT_ROLE | Character(30) | VARCHAR2(30) NOT NULL | Project Role |
| 16 | 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. |
| 17 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
| 18 | UPDATE_ENTRY | Character(1) | VARCHAR2(1) NOT NULL | Don't Post Duplicate Entries |
| 19 | SUN | Character(1) | VARCHAR2(1) NOT NULL | Sunday |
| 20 | MON | Character(1) | VARCHAR2(1) NOT NULL | Monday |
| 21 | SAT | Character(1) | VARCHAR2(1) NOT NULL | Saturday |
| 22 | TUES | Character(1) | VARCHAR2(1) NOT NULL | Tuesday |
| 23 | THURS | Character(1) | VARCHAR2(1) NOT NULL | Thursday |
| 24 | WED | Character(1) | VARCHAR2(1) NOT NULL | Wednesday |
| 25 | FRI | Character(1) | VARCHAR2(1) NOT NULL | Friday |
| 26 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL |
Task Category
Prompt Table: RS_TASK_CAT |
| 27 | DATE_IN_EFFECT | Date(10) | DATE |
01/27/2000 RML Added "As of date" label
03/23/2004 SFC Added PRICE_LIST_DATE label
06/04/2004 SFC Added PRODUCT_PRICE_DAT label
Default Value: %Date |