TIPS_EMPL_INPUT

(SQL Table)
Index Back

Tips Recording Input

Tips Recording Input

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_HR

3 TIPS_ESTAB Character(20) VARCHAR2(20) NOT NULL Tips Establishment ID
4 INPUT_DT Date(10) DATE Input Date
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON_NAME

6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
7 GRS_RCPTS Signed Number(16,2) DECIMAL(14,2) NOT NULL YTD Gross Receipts
8 GRS_TIPS Signed Number(16,2) DECIMAL(14,2) NOT NULL YTD Gross Tips
9 CHG_RCPTS Signed Number(16,2) DECIMAL(14,2) NOT NULL Charge Receipts
10 CHG_TIPS Signed Number(16,2) DECIMAL(14,2) NOT NULL Charge Tips
11 PY_SRVCHG_RCPTS Signed Number(16,2) DECIMAL(14,2) NOT NULL Service Charge Receipts
12 PY_SRVCHG_TIPS Signed Number(16,2) DECIMAL(14,2) NOT NULL Service Charge Tips