SFA_PG_CSH_DTL(SQL Table) |
Index Back |
---|---|
Pell SAS Cash Detail |
# | 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 | SFA_PG_SAS_DTLSEQ | Number(9,0) | DECIMAL(9) NOT NULL | Detail Sequence Number |
4 | PG_RECORD_INDIC | Character(1) | VARCHAR2(1) NOT NULL | Record Indicator |
5 | SFA_PG_BATCH_ID_00 | Character(26) | VARCHAR2(26) NOT NULL | Pell Batch ID |
6 | PG_REPORTING_ID | Character(6) | VARCHAR2(6) NOT NULL | Pell Reporting Campus ID |
7 | PG_ATTEND_ID | Character(6) | VARCHAR2(6) NOT NULL | Pell Attending Campus ID |
8 | PG_OPE_ID_NBR | Character(8) | VARCHAR2(8) NOT NULL | OPE ID Number |
9 | SFA_PG_REGION_CD | Character(2) | VARCHAR2(2) NOT NULL | Region Code |
10 | PG_INST_STATE | Character(2) | VARCHAR2(2) NOT NULL | Institution State |
11 | PG_PAYPER_END_DT | Character(8) | VARCHAR2(8) NOT NULL | Pay Period End Dt |
12 | SFA_PG_PROCESS_DT | Character(8) | VARCHAR2(8) NOT NULL | COD Process Date |
13 | SFA_PG_CSHTRN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Cash Transaction Type |
14 | SFA_PG_TRANS_DATE | Character(8) | VARCHAR2(8) NOT NULL | Transaction Date |
15 | SFA_PG_TRANS_AMOUT | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Transaction Amount |
16 | PG_PAY_CNTLNBR | Number(13,0) | DECIMAL(13) NOT NULL | Payment Control Number |
17 | PG_SOA_DTL_SEQ | Number(6,0) | INTEGER NOT NULL | Pell SOA Detail Sequence Nbr |