HP_BDCK_JOB_VW (SQL View)	Index Back
Budget Check for Employee view Budget check view for employee.

HP_BDCK_JOB_VW

(SQL View)

Budget Check for Employee view

Budget check view for employee.

SELECT J.EMPLID , J.EMPL_RCD , N.NAME , JD.DEPTID , JD.COMPANY , JD.PAYGROUP , JD.JOBCODE , J.HP_BUDGET_STATUS , J.HP_CRITICAL_TXN , J.HP_RTBC_TRIGGER , J.HP_RTBC_PERFORMED , J.HP_UPD_IN_PROGRESS , J.HP_LSTUPD_ENC_TIME FROM PS_HP_BDCK_LOG_JOB J , PS_JOB JD , PS_PERSON_NAME N WHERE J.EMPLID = JD.EMPLID AND J.EMPL_RCD = JD.EMPL_RCD AND J.EMPLID = N.EMPLID AND JD.EFFDT = ( SELECT MAX(JD1.EFFDT) FROM PS_JOB JD1 WHERE JD1.EMPLID = JD.EMPLID AND JD1.EMPL_RCD = JD.EMPL_RCD AND JD1.EFFDT <= %CurrentDateIn) AND JD.EFFSEQ = ( SELECT MAX(JD2.EFFSEQ) FROM PS_JOB JD2 WHERE JD2.EMPLID = JD.EMPLID AND JD2.EMPL_RCD = JD.EMPL_RCD AND JD2.EFFDT = JD.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

6 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
Prompt Table: PAYGROUP_TBL

7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

8 HP_BUDGET_STATUS Character(1) VARCHAR2(1) NOT NULL Commitment Control budget status
I=Invalid
P=Pending
V=Valid
X=Never Encumbered

9 HP_CRITICAL_TXN Character(1) VARCHAR2(1) NOT NULL Critical Transaction indicator

10 HP_RTBC_TRIGGER Character(1) VARCHAR2(1) NOT NULL RTBC Triggered indicator
B=Batch
J=Job Component
L=Initial Load
P=Position Component
R=Real Time

11 HP_RTBC_PERFORMED Character(1) VARCHAR2(1) NOT NULL RTBC Performed indicator

12 HP_UPD_IN_PROGRESS Character(1) VARCHAR2(1) NOT NULL This field is to indicate if update is in progress for a particular Doc ID. If it is "Yes", then the Doc ID is locked until the update is completed.

13 HP_LSTUPD_ENC_TIME DateTime(26) TIMESTAMP Last Encumbrance Update Time Stamp

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
6	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
7	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
8	HP_BUDGET_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control budget status I=Invalid P=Pending V=Valid X=Never Encumbered
9	HP_CRITICAL_TXN	Character(1)	VARCHAR2(1) NOT NULL	Critical Transaction indicator
10	HP_RTBC_TRIGGER	Character(1)	VARCHAR2(1) NOT NULL	RTBC Triggered indicator B=Batch J=Job Component L=Initial Load P=Position Component R=Real Time
11	HP_RTBC_PERFORMED	Character(1)	VARCHAR2(1) NOT NULL	RTBC Performed indicator
12	HP_UPD_IN_PROGRESS	Character(1)	VARCHAR2(1) NOT NULL	This field is to indicate if update is in progress for a particular Doc ID. If it is "Yes", then the Doc ID is locked until the update is completed.
13	HP_LSTUPD_ENC_TIME	DateTime(26)	TIMESTAMP	Last Encumbrance Update Time Stamp