HPIP_PRCS_PARAM

(SQL Table)
Index Back

Process Parameters

This table serves for tracking the runcontrol parameters that the process was started with.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 POSTING_DATE Date(10) DATE Posting Date
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
7 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
8 PAY_END_DT Date(10) DATE Pay Period End Date
9 OVERRIDE_IND Character(1) VARCHAR2(1) NOT NULL Override Indicator
10 HPIP_CONSOLIDATE Character(1) VARCHAR2(1) NOT NULL Consolidate Accounting Lines
11 HPIP_BALANCE Character(1) VARCHAR2(1) NOT NULL Balance Accounting Lines
12 HPIP_BK_SUSP Character(1) VARCHAR2(1) NOT NULL Book to Suspense Account
13 REQUEST_DT Date(10) DATE Request Date
14 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
15 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index
16 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
17 FROM_CUR_1 Character(3) VARCHAR2(3) NOT NULL From Currency
18 FROM_CUR_2 Character(3) VARCHAR2(3) NOT NULL From Currency
19 TO_CUR_1 Character(3) VARCHAR2(3) NOT NULL To Currency
20 TO_CUR_2 Character(3) VARCHAR2(3) NOT NULL To Currency