SFA_ASG_SARD_EC

(SQL Table)
Index Back

ACG/SMART SAR Detail record

ACG/SMART SAR Detail record.

# 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 GRANTEE_DUNS_NBR Character(11) VARCHAR2(11) NOT NULL Grantee DUNS Number
9 SFA_COMMON_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Common School ID for use with the Department of Education financial aid.
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 SFA_CR_BATCH_ID Character(30) VARCHAR2(30) NOT NULL Batch ID
16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
17 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

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