PeopleSoft 9
Account Payables

Table Name BUS_CAL_HOL_DFN

Table Description
BUS_CAL_HOL_DFN
Columns
Name Datatype Is PK Is FK
HOLIDAY_LIST_ID VARCHAR(10) Yes No
DESCR VARCHAR(30) No No
MON VARCHAR(1) No No
MON_HRS decimal(4,2) No No
TUES VARCHAR(1) No No
TUES_HRS decimal(4,2) No No
WED VARCHAR(1) No No
WED_HRS decimal(4,2) No No
THURS VARCHAR(1) No No
THURS_HRS decimal(4,2) No No
FRI VARCHAR(1) No No
FRI_HRS decimal(4,2) No No
SAT VARCHAR(1) No No
SAT_HRS decimal(4,2) No No
SUN VARCHAR(1) No No
SUN_HRS decimal(4,2) No No
Index
Name Type Unique Member
PS_BUS_CAL_HOL_DFN PK Yes
Member(s) of "PS_BUS_CAL_HOL_DFN" Index
HOLIDAY_LIST_ID

Published June 06, 2007