CS_DSP_HDR_HIST (SQL Table)	Index Back
Dispatch Hdr History info History information for dispatch -- mainly the subject/body of the email. Can't store in the main history table because of 2 longs. There are other fields related to dispatch that are on the main hdr_hist... because of upgrade impact .. not moving those.

CS_DSP_HDR_HIST

(SQL Table)

Dispatch Hdr History info

History information for dispatch -- mainly the subject/body of the email. Can't store in the main history table because of 2 longs. There are other fields related to dispatch that are on the main hdr_hist... because of upgrade impact .. not moving those.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID

2 CS_DOC_DISP_VER Number(3,0) SMALLINT NOT NULL Dispatch version/cycle

3 EMAIL_SUBJECT80 Character(80) VARCHAR2(80) NOT NULL Subject

4 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CS_DOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Document ID
2	CS_DOC_DISP_VER	Number(3,0)	SMALLINT NOT NULL	Dispatch version/cycle
3	EMAIL_SUBJECT80	Character(80)	VARCHAR2(80) NOT NULL	Subject
4	DESCRLONG	Long Character	CLOB	Long Description