HGA_CAN_APPR_VW(SQL View) |
Index Back |
|---|---|
Absence Cancelation requestsView to retrieve Absence Cancelation requests belong to a Manager using AWE tables. |
| SELECT DISTINCT R.EMPLID , R.EMPL_RCD , Z.NAME , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 'N' , R.TRANSACTION_NBR , R.BGN_DT , R.PIN_TAKE_NUM , R.END_DT , R.ORIG_EMPLID , R.ORIG_EMPL_RCD , R.ORIG_BEGIN_DT , R.ORIG_PIN_TAKE_NUM , R.ORIG_END_DT , R.ELIG_GRP , C.JOBTITLE , CASE WHEN R.WF_STATUS <> ' ' THEN R.WF_STATUS ELSE CASE WHEN R.MANAGER_APPR_IND = 'Y' THEN 'A' ELSE 'V' END END , R.DURATION_ABS , R.ACTION_DT_SS , S.EOAWSTEP_STATUS , R.ABS_ENTRY_SRC , S.OPRID , R.MANAGER_APPR_IND , 'CAN' , X.EOAWPRCS_ID FROM PS_HGA_CAN_XREF X , PS_EOAW_STEP_VW S , PS_GP_ABSSS_PNDG_2 R , PS_GP_ABS_EEJOB_VW C , PS_PERSON_NAME Z WHERE X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND R.TRANSACTION_NBR = X.TRANSACTION_NBR AND R.EMPLID = Z.EMPLID AND R.EMPLID = C.EMPLID AND R.EMPL_RCD = C.EMPL_RCD AND X.EOAWPARENT_THREAD = ( SELECT MAX(Y.EOAWPARENT_THREAD) FROM PS_HGA_CAN_XREF Y WHERE X.TRANSACTION_NBR = Y.TRANSACTION_NBR AND Y.EOAWTHREAD_STATUS <> 'T') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: TL_EMPL_NAME_VW |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |
| 7 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 8 | JOB_DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Job Description
Prompt Table: TL_JOB_DESC_VW |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 10 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 11 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL |
Supervisor ID
Prompt Table: TL_SUPRVSR_VW |
| 12 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL |
Reports To Position Number
Prompt Table: TL_RPTS_TO_VW |
| 13 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 14 | LOC_DESCR_SS | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 15 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 16 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
North American Pay Group
Prompt Table: PAYGROUP_TBL |
| 17 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 18 | WORKGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Workgroup
Prompt Table: TL_WRKGRP_TBL |
| 19 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Taskgroup
Prompt Table: TL_TASKGRP_TBL |
| 20 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 21 | SCHEDULE_GRP | Character(10) | VARCHAR2(10) NOT NULL | Scheduling Organizational Group Code |
| 22 | PROCESSED | Character(1) | VARCHAR2(1) NOT NULL |
Processed?
I=In Process N=Not Processed Y=Processed Y/N Table Edit Default Value: N |
| 23 | TRANSACTION_NBR | Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 24 | BGN_DT | Date(10) | DATE | Begin Date |
| 25 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_ABSTK_VW |
| 26 | END_DT | Date(10) | DATE | end date |
| 27 | ORIG_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Originating Emplid |
| 28 | ORIG_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 29 | ORIG_BEGIN_DT | Date(10) | DATE | original begin date |
| 30 | ORIG_PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
| 31 | ORIG_END_DT | Date(10) | DATE | Unadjusted End Date |
| 32 | ELIG_GRP | Character(10) | VARCHAR2(10) NOT NULL | eligibility group |
| 33 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 34 | WF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved |
| 35 | DURATION_ABS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration field containing 2 decimals to handle absence requirements |
| 36 | ACTION_DT_SS | Date(10) | DATE | Termination Date |
| 37 | AWSTEP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Step Instance Status
A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending S=Skipped T=Terminated U=Auto approved X=Deleted Y=Bypassed |
| 38 | ABS_ENTRY_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Absence Entry Source
1=Administrator Absence Event 2=Time & Labor 3=Third Party 4=Employee Absence Request 5=Manager Absence Request 6=Employee Timesheet 7=Manager Timesheet A=Employee Extended Absence B=Manager Extended Absence C=Administrator Extended Absence D=Employee Desktop Integration |
| 39 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 40 | MANAGER_APPR_IND | Character(1) | VARCHAR2(1) NOT NULL | Manager Approved |
| 41 | HGA_APPR_PRCS | Character(3) | VARCHAR2(3) NOT NULL |
Absence Approval Process Type
REQ - Absence Request
CAN - Absence Cancellation
CAN=Absence Cancelation REQ=Absence Request |
| 42 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |