PA_JOB_VW2(SQL View) |
Index Back |
---|---|
All Job Info for PensionJOB is one of the core records in the database. Use it to record an employee's job history data such as actions taken, department, job code, location, and salary history. This view is a snapshot of certain fields within the JOB record at today's date. |
SELECT emplid , EMPL_RCD , effdt , effseq , empl_status , ACTION , action_dt , action_reason , reg_temp , full_part_time , company , paygroup , empl_type , std_hours , std_hrs_frequency , hourly_rt , monthly_rt , annual_rt , sal_admin_plan , jobcode , position_nbr , deptid , location , business_unit FROM PS_JOB |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW Prompt Table: PERSON |
2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
3 | EFFDT | Date(10) | DATE | Effective Date |
4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
5 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration Default Value: A |
6 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
7 | ACTION_DT | Date(10) | DATE |
Action Date
Default Value: %date |
8 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
9 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary Default Value: R |
10 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time Default Value: F |
11 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
12 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
13 | EMPL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly H=Hourly N=Not Applicable S=Salaried |
14 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
15 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Standard Work Period
Prompt Table: STDHRS_FREQ_VW |
16 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
17 | MONTHLY_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Monthly Rate |
18 | ANNUAL_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Annual Rate |
19 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
20 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
21 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
22 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
23 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
24 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |