| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SFA_PG_SAS_RUN_DT |
Date(10) |
DATE |
PELL SAS Run Date
|
| 2 |
SFA_PG_SAS_SEQ_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
PELL SAS - Sequence Number
|
| 3 |
PG_TRAILER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pell Trailer ID
|
| 4 |
PG_RECORD_LENGTH |
Character(4) |
VARCHAR2(4) NOT NULL |
Pell Record Length
|
| 5 |
SFA_PG_BATCH_ID_00 |
Character(26) |
VARCHAR2(26) NOT NULL |
Pell Batch ID
|
| 6 |
PG_TRLR_NBR_RPTD |
Character(6) |
VARCHAR2(6) NOT NULL |
Pell Trailer Nbr Recs Rptd
|
| 7 |
PG_TRLR_TOT_RPRT |
Character(11) |
VARCHAR2(11) NOT NULL |
Pell Trailer Batch Total Rptd
|
| 8 |
PG_TRLR_SIGN_RPRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pell Trailer Sign Ind Rptd
|
| 9 |
PG_TRLR_NBR_ACPT |
Character(6) |
VARCHAR2(6) NOT NULL |
Pell Trailer Nbr Recs Acpt
|
| 10 |
PG_TRLR_TOT_ACPT |
Character(11) |
VARCHAR2(11) NOT NULL |
Pell Trailer Batch Total Acpt
|
| 11 |
PG_TRLR_SIGN_ACPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pell Trailer Sign Ind Acpt
|
| 12 |
PG_NBR_DUP_REC |
Character(6) |
VARCHAR2(6) NOT NULL |
Pell Nbr of Duplicate Records
|