RS_ELGBL_WRKR(SQL Table) |
Index Back |
|---|---|
Current Eligible Resource InfoThis table is going to list current eligible Resource info in Resource Management. It is going to be updated by Resource Management through transactions and an Application Engine. SUJ--Included SYSTEM_SOURCE field to store the product type as the table will also list eligible resources under Work Oder Mgmt . |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SYSTEM_SOURCE |
Character(3) | VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
Default Value: RS |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 7 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 8 | HOLIDAY_SCHEDULE | Character(6) | VARCHAR2(6) NOT NULL | Holiday Schedule |
| 9 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 10 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Standard Work Period |
| 11 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
| 12 | PER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Person Type
A=Applicant C=Cobra Participant D=GP Dependent/Beneficiary E=Leased Worker I=Independent Contractor L=Time & Labor Contractor M=Temporary Worker N=Non HR Administered Employee O=Other Non-Employee P=Pension Payee S=Stock Non-Employee T=Training Non-Employee U=Succession Candidate Non-Emplo |
| 13 | BILL_RATE_CV | Number(27,3) | DECIMAL(26,3) NOT NULL | Converted Bill Rate |
| 14 | BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | STD_DAY_PERCENT | Number(7,4) | DECIMAL(6,4) NOT NULL | The standard work day represented as a ratio of the worker's standard day to the general standard day. |
| 17 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 18 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 19 | SETID_REGION | Character(5) | VARCHAR2(5) NOT NULL | Region SetID |
| 20 | 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. |
| 21 | SETID_ROLE | Character(5) | VARCHAR2(5) NOT NULL | SetID Role is used in the resource profile to allow select a valid project role. |
| 22 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |