HP_ENCUMB_AET

(SQL Table)
Index Back

Encumbrance Batch AET

Encumbrance Batch AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
5 RUN_WITH_ERRORS Character(1) VARCHAR2(1) NOT NULL Run with Errors

Default Value: Y

6 DIST_PRORATE_OPTN Character(1) VARCHAR2(1) NOT NULL Distribution Prorate Option
C=Calendar Days
I=For Internal System Use Only
N=Not Applicable
W=Work Days
7 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
8 RUNDATE Date(10) DATE Process Scheduler Run Date
9 HP_ENC_PROC_OPT Character(1) VARCHAR2(1) NOT NULL Processing Option
1=By Pay Run
2=By Company / Paygroup
3=By Budget Status
4=By Table Change
10 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
11 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
12 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
13 COMMIT_LEVEL Number(5,0) INTEGER NOT NULL Commit Level
14 HP_BUDGET_STATUS Character(1) VARCHAR2(1) NOT NULL Commitment Control budget status
I=Invalid
P=Pending
V=Valid
X=Never Encumbered
15 ROWS_RETRIEVED Number(9,0) DECIMAL(9) NOT NULL Number of Rows Retrieved
16 SQL_STMT_254 Character(254) VARCHAR2(254) NOT NULL An internal work field that contains SQL text that is to be utilized in treasury application p
17 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section