CARR_SHEX_DT_VW

(SQL View)
 Index Back

Shipment Exception Date/Time

This table stores the standing daily exception dates and times that a carrier cannot ship deliveries. This table is consulted during quotation and order entry when trying to determine a scheduled arrival date.

SELECT C.SETID , C.CARRIER_ID , C.EFFDT , D.SHIP_DAY , D.TIME_FROM , D.TIME_TO , C.EFF_STATUS , D.NO_DRIVE , D.NO_PICKUP FROM PS_CARRIER_ID C , PS_CARRIER_SHEX_DT D WHERE %Join(COMMON_KEYS, CARRIER_ID C, CARRIER_SHEX_DT D)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 SHIP_DAY Character(1) VARCHAR2(1) NOT NULL Day of Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
5 TIME_FROM Time(15) TIMESTAMP NOT NULL From Time
6 TIME_TO Time(15) TIMESTAMP NOT NULL To Time
7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
8 NO_DRIVE Character(1) VARCHAR2(1) NOT NULL No Drive
9 NO_PICKUP Character(1) VARCHAR2(1) NOT NULL No Pickup