TP_CONTRACT_VW(SQL View) |
Index Back |
|---|---|
Third Party Contracts View |
| SELECT A.BUSINESS_UNIT ,A.EXT_ORG_ID ,A.CONTRACT_NUM ,A.TP_CON_TYPE ,A.START_DT ,A.END_DT ,A.ORG_CODE ,A.TP_CAP_CONTRACT ,A.TP_STATUS ,A.ITEM_TYPE ,A.PMT_ITEM_TYPE ,A.ACCOUNT_TYPE_SF ,A.TP_CAP_STUDENT ,A.TP_CONTRACT_TYPE FROM PS_TP_CONTRACT A WHERE A.TP_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 3 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 4 | TP_CON_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Third Party Contract Type
C=Collection Agreement D=Deferral Contract M=Multi-year Payment Plan P=Payment Plan R=Pre-Payment Plan T=Third Party |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL | Organization Code |
| 8 | TP_CAP_CONTRACT | Number(15,2) | DECIMAL(14,2) NOT NULL | Contract Max |
| 9 | TP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contract Status
A=Active C=Cancelled H=Hold I=Inactive U=Not Posted Default Value: A |
| 10 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: ITEM_TYPE_CH_VW |
| 11 | PMT_ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Payment Item Type
Prompt Table: ITEM_TYPE_PY_VW |
| 12 | ACCOUNT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL |
Account Type
Prompt Table: ACCT_TYP_TBL_SF |
| 13 | TP_CAP_STUDENT | Number(15,2) | DECIMAL(14,2) NOT NULL | Third Party Student Maximum |
| 14 | TP_CONTRACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Third Party Contract Type
C=Specific Course L=Specific Course List P=Specific Year or Period T=Specific Term |