WM_ELGBL_WRKR(SQL View) |
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 Order Mgmt . |
| SELECT EMPLID , EMPL_RCD , BUSINESS_UNIT , JOBCODE , DEPTID , SUPERVISOR_ID , HOLIDAY_SCHEDULE , STD_HOURS , STD_HRS_FREQUENCY , PER_STATUS , PER_TYPE , BILL_RATE_CV , BILL_RATE , CURRENCY_CD , STD_DAY_PERCENT , NAME ,LOCATION FROM PS_RS_ELGBL_WRKR WHERE SYSTEM_SOURCE = 'WM' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 5 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 6 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 7 | HOLIDAY_SCHEDULE | Character(6) | VARCHAR2(6) NOT NULL | Holiday Schedule |
| 8 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 9 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Standard Work Period |
| 10 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
| 11 | 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 |
| 12 | BILL_RATE_CV | Number(27,3) | DECIMAL(26,3) NOT NULL | Converted Bill Rate |
| 13 | BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 15 | 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. |
| 16 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 17 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |