GVT_FA_PARDT_VW

(SQL View)
 Index Back

PAR Details for Fluid Approval

This view would fetch information required to display the PAR details in Fluid Approvals.

SELECT JOB.EMPLID , JOB.EMPL_RCD , JOB.EFFDT , JOB.EFFSEQ , ACTN.ACTION_DESCR , RSN.DESCR , JOB.GVT_NOA_CODE , NOAC.DESCR25 , XLAT.XLATLONGNAME , WIP.XLATLONGNAME , '' FROM PS_GVT_JOB JOB , PS_ACTION_TBL ACTN , PS_ACTN_REASON_TBL RSN , PS_GVT_NOAC_TBL NOAC , PSXLATITEM XLAT , PSXLATITEM WIP WHERE JOB.ACTION = ACTN.ACTION AND %EffdtCheck(ACTION_TBL A,ACTN,JOB.EFFDT) AND ACTN.EFF_STATUS = 'A' AND JOB.ACTION = RSN.ACTION AND JOB.ACTION_REASON = RSN.ACTION_REASON AND %EffdtCheck(ACTN_REASON_TBL R,RSN,JOB.EFFDT) AND RSN.EFF_STATUS = 'A' AND JOB.ACTION = NOAC.ACTION AND JOB.GVT_NOA_CODE = NOAC.GVT_NOA_CODE AND %EffdtCheck(GVT_NOAC_TBL N,NOAC,JOB.EFFDT) AND NOAC.EFF_STATUS = 'A' AND XLAT.FIELDNAME = 'EMPL_STATUS' AND XLAT.FIELDVALUE = JOB.EMPL_STATUS AND %EffdtCheck(PSXLATITEM E,XLAT,JOB.EFFDT) AND XLAT.EFF_STATUS = 'A' AND WIP.FIELDNAME = 'GVT_STATUS' AND WIP.FIELDVALUE = JOB.GVT_WIP_STATUS AND %EffdtCheck(PSXLATITEM W,WIP,JOB.EFFDT) AND WIP.EFF_STATUS = 'A'

# 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 NOT NULL Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code
8 DESCR25 Character(25) VARCHAR2(25) NOT NULL Short description
9 GVT_EMPL_STS_DESCR Character(30) VARCHAR2(30) NOT NULL Employee Status Description
10 GVT_DESCR_WIP_STAT Character(30) VARCHAR2(30) NOT NULL WIP status description.
11 GVT_EFFDT_STR Character(10) VARCHAR2(10) NOT NULL Show/store effective date as a string.