PG_SARD_00_EC

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)

2 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.

3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
Default Value: I

4 PG_SOA_SEQ Number(3,0) SMALLINT NOT NULL Pell SOA Sequence Number

5 PG_SOA_DTL_SEQ Number(6,0) INTEGER NOT NULL Pell SOA Detail Sequence Nbr

6 PG_RECORD_INDIC Character(1) VARCHAR2(1) NOT NULL Record Indicator

7 TIV_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL Pell ID Reporting

8 PG_GRANTEE_DUNS Character(9) VARCHAR2(9) NOT NULL Pell Grantee DUNS Num

9 PG_PAYEE_DUN Character(9) VARCHAR2(9) NOT NULL Payee DUNS Number

10 PG_GAPS_AWARD_NBR Character(16) VARCHAR2(16) NOT NULL GAPS Award Number

11 PG_ADJ_REPORT_DATE Date(10) DATE Adjustment Report Date

12 PG_DEBIT_CREDIT Character(1) VARCHAR2(1) NOT NULL Debit/Credit Indicator

13 PG_ADJAMT Number(12,2) DECIMAL(11,2) NOT NULL Adjustment Amount

14 PG_ADJM_PROC_DT Date(10) DATE Adjustment Process Date

15 PG_ADJ_BATCH_NBR Character(26) VARCHAR2(26) NOT NULL Adjustment Batch Number

16 PG_ADJ_DESCR Character(20) VARCHAR2(20) NOT NULL Adjustment Description

17 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

18 PG_STG_PROC_STAT Character(1) VARCHAR2(1) NOT NULL Pell Staging Rec Proc Status
E=Error
N=Not Processed
P=Processed
Default Value: N

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

20 SFA_PG_GRANTEE_UEI Character(12) VARCHAR2(12) NOT NULL Grantee UEI Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
2	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.
3	ECTRANSINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound Default Value: I
4	PG_SOA_SEQ	Number(3,0)	SMALLINT NOT NULL	Pell SOA Sequence Number
5	PG_SOA_DTL_SEQ	Number(6,0)	INTEGER NOT NULL	Pell SOA Detail Sequence Nbr
6	PG_RECORD_INDIC	Character(1)	VARCHAR2(1) NOT NULL	Record Indicator
7	TIV_SCHOOL_CODE	Character(6)	VARCHAR2(6) NOT NULL	Pell ID Reporting
8	PG_GRANTEE_DUNS	Character(9)	VARCHAR2(9) NOT NULL	Pell Grantee DUNS Num
9	PG_PAYEE_DUN	Character(9)	VARCHAR2(9) NOT NULL	Payee DUNS Number
10	PG_GAPS_AWARD_NBR	Character(16)	VARCHAR2(16) NOT NULL	GAPS Award Number
11	PG_ADJ_REPORT_DATE	Date(10)	DATE	Adjustment Report Date
12	PG_DEBIT_CREDIT	Character(1)	VARCHAR2(1) NOT NULL	Debit/Credit Indicator
13	PG_ADJAMT	Number(12,2)	DECIMAL(11,2) NOT NULL	Adjustment Amount
14	PG_ADJM_PROC_DT	Date(10)	DATE	Adjustment Process Date
15	PG_ADJ_BATCH_NBR	Character(26)	VARCHAR2(26) NOT NULL	Adjustment Batch Number
16	PG_ADJ_DESCR	Character(20)	VARCHAR2(20) NOT NULL	Adjustment Description
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	PG_STG_PROC_STAT	Character(1)	VARCHAR2(1) NOT NULL	Pell Staging Rec Proc Status E=Error N=Not Processed P=Processed Default Value: N
19	PELL_TRANS_DTTM	DateTime(26)	TIMESTAMP	Pell Trans Date/Time
20	SFA_PG_GRANTEE_UEI	Character(12)	VARCHAR2(12) NOT NULL	Grantee UEI Number