RTBL_RUN_ALLLOG

(SQL Table)
Index Back

Allocation Processes

Allocation Processes with Calculation Log.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

4 PROCESS_STEP Character(10) VARCHAR2(10) NOT NULL Process Step

Prompt Table: ALLOC_STEP_VW2

5 PROCESS_BEGIN Number(10,0) DECIMAL(10) NOT NULL Begin Process Instance

Prompt Table: %EDITTABLE3

6 PROCESS_END Number(10,0) DECIMAL(10) NOT NULL End Process Instance

Prompt Table: %EDITTABLE3

7 DISPLAY_26_DIGITS Character(1) VARCHAR2(1) NOT NULL Display Full Numeric Field
N=No
Y=Yes

Default Value: N

8 RTBL_SCENARIO Character(18) VARCHAR2(18) NOT NULL Scenario Name

Prompt Table: %EDITTABLE4

9 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
10 STEP_DESCR Character(30) VARCHAR2(30) NOT NULL Description field for salary step