HCR_FA_JOBDT_VW

(SQL View)
 Index Back

Job Details for Fluid Approval

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

SELECT JOB.EMPLID , JOB.EMPL_RCD , JOB.EFFDT , JOB.EFFSEQ , HCR_ACTN_SEQN , ACTN.ACTION_DESCR , %Coalesce (( SELECT RSN.DESCR FROM PS_ACTN_REASON_TBL RSN WHERE 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' ), '') , '' FROM PS_ACTION_TBL ACTN , PS_HCR_JOB_STG JOB WHERE JOB.ACTION = ACTN.ACTION AND %EffdtCheck(ACTION_TBL A,ACTN,JOB.EFFDT) AND ACTN.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 HCR_ACTN_SEQN Number(3,0) SMALLINT NOT NULL Sequence number
6 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 EFFDT_STR Character(10) VARCHAR2(10) NOT NULL Show/store effective date as a string.