ENCUMB_DIST (SQL Table)	Index Back
Encumbrance Earnings ENCUMB_DIST_ERN contains the estimated earnings pre-encumbrances and encumbrances for a given fiscal year. These records are created by the Fiscal Year and Nightly Encumbrance batch processes.

ENCUMB_DIST

(SQL Table)

Encumbrance Earnings

ENCUMB_DIST_ERN contains the estimated earnings pre-encumbrances and encumbrances for a given fiscal year. These records are created by the Fiscal Year and Nightly Encumbrance batch processes.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HP_KK_DOC_ID Number(31,0) DECIMAL(31) NOT NULL Commitment Control Document ID

2 HP_KK_DOC_LINE_NBR Number(3,0) SMALLINT NOT NULL Commitment Control Document Line #

3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

4 HP_BUDGET_YEAR Number(4,0) SMALLINT NOT NULL Budget Year for Commitment Control

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: PER_ORG_ASGN_VW

7 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA

8 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
Prompt Table: HRS_JOB_OPENING

9 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID
Prompt Table: POOL_TBL

10 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
Prompt Table: SET_JOB_DEP_VW

11 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Prompt Table: JOBCODE_TBL

12 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SETID_TBL

13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

14 ENCUMB_PROC_TYPE Character(2) VARCHAR2(2) NOT NULL Indicate the encumbrance type on Budget Actuals and Encumbrance Distribution record.
ED=Encumber Deduction
EE=Encumber Salary
ET=Encumber Tax
PD=Postiion PreEncumber Deduction
PE=Position PreEncumber Salary
PT=Position PreEncumber Tax
RD=Job Req PreEncumber Deduction
RE=Job Req PreEncumber Salary
RT=Job Req PreEncumber Tax

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

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

17 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit

18 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

19 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
Prompt Table: GL_ACCOUNT_TBL

20 ENCUMB_POSTED Character(1) VARCHAR2(1) NOT NULL Encumbrance Posted?
Y/N Table Edit

21 ENCUMBERED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Amount Encumbered

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HP_KK_DOC_ID	Number(31,0)	DECIMAL(31) NOT NULL	Commitment Control Document ID
2	HP_KK_DOC_LINE_NBR	Number(3,0)	SMALLINT NOT NULL	Commitment Control Document Line #
3	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
4	HP_BUDGET_YEAR	Number(4,0)	SMALLINT NOT NULL	Budget Year for Commitment Control
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: PER_ORG_ASGN_VW
7	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
8	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone Prompt Table: HRS_JOB_OPENING
9	POSITION_POOL_ID	Character(3)	VARCHAR2(3) NOT NULL	Position Pool ID Prompt Table: POOL_TBL
10	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID Prompt Table: SET_JOB_DEP_VW
11	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
12	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL
13	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
14	ENCUMB_PROC_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Indicate the encumbrance type on Budget Actuals and Encumbrance Distribution record. ED=Encumber Deduction EE=Encumber Salary ET=Encumber Tax PD=Postiion PreEncumber Deduction PE=Position PreEncumber Salary PT=Position PreEncumber Tax RD=Job Req PreEncumber Deduction RE=Job Req PreEncumber Salary RT=Job Req PreEncumber Tax
15	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
16	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
17	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
18	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
19	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCOUNT_TBL
20	ENCUMB_POSTED	Character(1)	VARCHAR2(1) NOT NULL	Encumbrance Posted? Y/N Table Edit
21	ENCUMBERED_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Amount Encumbered