GP_ABS_APPR_VW(SQL View) |
Index Back |
---|---|
Absence SS according to AWEView to retrieve Absence Events belong to a Manager using AWE tables. |
SELECT DISTINCT R.TRANSACTION_NBR , R.EMPLID , R.EMPL_RCD , 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 , Z.NAME , C.JOBTITLE , D.DESCR , R.WF_STATUS , R.DURATION_ABS , R.ACTION_DT_SS , S.PTAFSTEP_STATUS , S.OPRID FROM PS_GP_ABSSS_V_XREF X , PS_PTAFAW_STEP_VW S , PS_GP_ABSSS_PNDG_2 R , PS_GP_ABS_EEJOB_VW C , PS_GP_PIN D , PS_PERSON_NAME Z WHERE X.PTAFTHREAD_ID = S.PTAFTHREAD_ID AND X.PTAFPRCS_ID = S.PTAFPRCS_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 D.PIN_NUM = R.ORIG_PIN_TAKE_NUM AND X.PTAFPARENT_THREAD = ( SELECT MAX(Y.PTAFPARENT_THREAD) FROM PS_GP_ABSSS_V_XREF Y WHERE X.TRANSACTION_NBR = Y.TRANSACTION_NBR AND Y.PTAFTHREAD_STATUS <> 'T') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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. |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
4 | BGN_DT | Date(10) | DATE | Begin Date |
5 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_ABSTK_VW |
6 | END_DT | Date(10) | DATE | end date |
7 | ORIG_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Originating Emplid |
8 | ORIG_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
9 | ORIG_BEGIN_DT | Date(10) | DATE | original begin date |
10 | ORIG_PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
11 | ORIG_END_DT | Date(10) | DATE | Original END_DT before adjust |
12 | ELIG_GRP | Character(10) | VARCHAR2(10) NOT NULL | eligibility group |
13 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
14 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
16 | 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 |
17 | DURATION_ABS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration field containing 2 decimals to handle absence requirements |
18 | ACTION_DT_SS | Date(10) | DATE | Termination Date |
19 | 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 |
20 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |