TRW_BLD_AET

(SQL Table)
Index Back

TRW Reward Build State Record

This is a state record utilized by the Reward Build process (TRW_BLD_STMT)

# 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 TRW_STMT_ID Character(15) VARCHAR2(15) NOT NULL Reward Statement ID
5 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.
6 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index
7 TRW_DESCR50 Character(50) VARCHAR2(50) NOT NULL Description field character 50
8 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
9 TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Template ID
10 FROMDATE Date(10) DATE From Date
11 THRUDATE Date(10) DATE End Date
12 TRW_STMT_STATUS Character(3) VARCHAR2(3) NOT NULL TRW Statement Status
ABC=Amend Build Complete
ABE=Amend Build Error
AEC=Amend Extract Complete
AEE=Amend Extract Error
AEM=Amending Employees
BLC=Build Rewards Complete
BLE=Build Rewards Error
CAN=Statement Cancelled
DEF=Defined
EDV=External Data Validated
EXC=Extract Rewards Complete
EXE=Extract Rewards Error
SPB=Reward Statements Published
13 TRW_PROCESS_IND Character(1) VARCHAR2(1) NOT NULL TRW Process Indicator
14 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code
15 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code
16 RT_RATE Number(16,8) DECIMAL(15,8) NOT NULL Market Rate
17 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions
18 TRW_SECTION_ID Character(10) VARCHAR2(10) NOT NULL Section ID for sections in total rewards template.setup
19 TRW_RW_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Total rewards statement - reward item ID
20 AE_TEST_FLAG Character(1) VARCHAR2(1) NOT NULL Test Flag