TIPS_ALL_RUNCTL

(SQL Table)
Index Back

Tips Allocation Run Control

The Pay Calculation Run Control record manages the pay calculation process.

# 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

4 POST_DT Date(10) DATE NOT NULL The Date a transaction was Posted.

Prompt Table: TIPS_ALLOC_PD

5 TIPS_CALC_INP Character(1) VARCHAR2(1) NOT NULL Calculate Allocated Tips

Y/N Table Edit

Default Value: N

6 TIPS_APPR_INP Character(1) VARCHAR2(1) NOT NULL Approve Allocated Tips

Y/N Table Edit

Default Value: N

7 LOAD_EARNS Character(1) VARCHAR2(1) NOT NULL Load Allocations to Payroll

Y/N Table Edit

8 START_DATE Date(10) DATE Start Date for Gen Standing PO