| # |
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 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
TIPS_ESTAB |
Character(20) |
VARCHAR2(20) NOT NULL |
Tips Establishment ID
Prompt Table:
%EDITTABLE
|
| 5 |
PY_TIPS_SERIAL_NBR |
Number(5,0) |
INTEGER NOT NULL |
Establishment Serial Number
|
| 6 |
PY_TIPS_EST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Tips Establishment Name
|
| 7 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Default Value: USA
|
| 8 |
PY_EST_STR_ADDRESS |
Character(40) |
VARCHAR2(40) NOT NULL |
Street address for Tips Establishment
|
| 9 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 10 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 11 |
ZIP |
Character(10) |
VARCHAR2(10) NOT NULL |
Postal Code
|
| 12 |
PY_TIPS_EST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Establishment Type
1=Serves Evening Meals Only
2=Serves Evening and Other Meals
3=Meals Other Than Evening Meals
4=Serves Food as Incidental Part
Default Value: 2
|
| 13 |
PY_TIPS_CHARGE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Charge Cards Accepted
N=Do not accept Charge cards
Y=Accept Charge cards
Y/N Table Edit
Default Value: Y
|
| 14 |
MIN_TIPS_PCT |
Number(9,5) |
DECIMAL(8,5) NOT NULL |
Minimum Tips Percent
Default Value: COMPANY_TBL.MIN_TIPS_PCT
|
| 15 |
TIPS_ALLOC_METH |
Character(1) |
VARCHAR2(1) NOT NULL |
Tips Allocation Method
F=Good Faith (Custom)
H=Hours Worked
R=Gross Receipts
Default Value: COMPANY_TBL.TIPS_ALLOC_METH
|
| 16 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|