BUDGET_ACTAD_VW

(SQL View)
 Index Back

SELECT SETID , DEPTID , POSITION_POOL_ID , SETID_JOBCODE , JOBCODE , POSITION_NBR , EMPLID , EMPL_RCD , ENCUMB_PROC_TYPE , FISCAL_YEAR , ACCT_CD FROM PS_BUDGET_ACTUALS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_HR.SETID

Prompt Table: SETID_TBL

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

Prompt Table: DEPT_TBL

3 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID

Prompt Table: POOL_TBL

4 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

Prompt Table: SET_JOB_DEP_VW

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

Prompt Table: JOBCODE_TBL

6 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

Prompt Table: POSITION_DATA

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

Prompt Table: PERSON

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

Prompt Table: PER_ORG_ASGN_VW

9 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
10 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
11 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

Prompt Table: ACCT_CD_CA_VW