INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
BATCH_IDCN=Canceled
ER=Errors Encountered
OH=On Hold
PN=Pending
PT=Posted
AWARD_POST_HDR(SQL Table) |
Index Back |
|---|---|
Award Posting HeaderBatch Packaging - header record for award posting. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | BATCH_ID |
Character(12) | VARCHAR2(12) NOT NULL | Batch ID |
| 3 | BATCH_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Batch Status
CN=Canceled ER=Errors Encountered OH=On Hold PN=Pending PT=Posted |
| 4 | DATE_ENTERED | Date(10) | DATE | Date Entered |
| 5 | OPERATOR | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 6 | TOTAL_TXN | Number(3,0) | SMALLINT NOT NULL | Total transactions |
| 7 | TOTAL_AWARDED | Number(3,0) | SMALLINT NOT NULL | Total Awarded |
| 8 | TOTAL_REJECTED | Number(3,0) | SMALLINT NOT NULL | Total Rejected |
| 9 | DATE_OF_LAST_EDIT | Date(10) | DATE | Date of Last Edit |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | TOTAL_CALC_TXNS | Number(3,0) | SMALLINT NOT NULL | Calculated Total Transactions |