SFA_PG_CSH_SUMM(SQL Table) |
Index Back |
---|---|
Pell SAS Cash Summary |
# | 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_OPE_ID_NBR | Character(8) | VARCHAR2(8) NOT NULL | OPE ID Number |
8 | SFA_PG_REGION_CD | Character(2) | VARCHAR2(2) NOT NULL | Region Code |
9 | PG_INST_STATE | Character(2) | VARCHAR2(2) NOT NULL | Institution State |
10 | PG_PAYPER_END_DT | Character(8) | VARCHAR2(8) NOT NULL | Pay Period End Dt |
11 | SFA_PG_PROCESS_DT | Character(8) | VARCHAR2(8) NOT NULL | COD Process Date |
12 | SFA_PG_CSHSUM_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Cash Summary Type |
13 | SFA_PG_CASH_BAL | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Beginning Cash Balance |
14 | SFA_PG_NETDRAW_PAY | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Net Drawdown/Payments |
15 | SFA_PG_NAPD | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | NAPD |
16 | SFA_PG_CSH_GT_NAPD | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Cash GT NAPD |
17 | PG_SOA_DTL_SEQ | Number(6,0) | INTEGER NOT NULL | Pell SOA Detail Sequence Nbr |