PG_HDR_ORIG_VW (SQL View)	Index Back
Pell Header View Used in run control panels for pell grant crystal reports.

PG_HDR_ORIG_VW

(SQL View)

Pell Header View

Used in run control panels for pell grant crystal reports.

SELECT ECQUEUEINSTANCE, PG_BATCH_ID_00, PELL_TRANS_DTTM, OPRID FROM PS_PG_HDR_00_EC WHERE PG_BATCH_ID_00 LIKE '#O%' AND ECTRANSID LIKE 'PGOR%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.

2 PG_BATCH_ID_00 Character(26) VARCHAR2(26) NOT NULL Pell Batch ID

3 PELL_TRANS_DTTM DateTime(26) TIMESTAMP Pell Trans Date/Time

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
2	PG_BATCH_ID_00	Character(26)	VARCHAR2(26) NOT NULL	Pell Batch ID
3	PELL_TRANS_DTTM	DateTime(26)	TIMESTAMP	Pell Trans Date/Time
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).