SSF_INXTSUM_TMP(SQL Table) |
Index Back |
|---|---|
Term Summary SF |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | INVOICE_ID |
Character(22) | VARCHAR2(22) NOT NULL | Invoice Number |
| 4 | ITEM_TYPE_CD |
Character(1) | VARCHAR2(1) NOT NULL |
Item Type Code
A=Application Fee B=Billing Only C=Charge D=Deposit F=Financial Aid G=GL Interface Only H=Withholding I=Interest L=Pre-Paid Tuition P=Payment R=Refund T=Transfers V=Contributor Relations W=Waiver X=Write-off Z=Pay Plan Credit |
| 5 | ITEM_TERM |
Character(4) | VARCHAR2(4) NOT NULL | Item Term |
| 6 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 7 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 8 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 9 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 10 | ITEM_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Item Amount |
| 11 | ITEM_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Item Description |
| 12 | TERM_DESCR | Character(10) | VARCHAR2(10) NOT NULL | Term Descr |