SSF_TPCROLL_VW

(SQL View)
 Index Back

TP Contracts View

TP Contracts View. View is used to pull active, un-expired third-party contracts and populate run control grid for TPC Rollover process.

SELECT BUSINESS_UNIT , CONTRACT_NUM , TP_CONTRACT_TYPE , DESCR , EXT_ORG_ID , STRM , COURSE_LIST , SSF_TPCON_USERDEF1 , SSF_TPCON_USERDEF2 , SSF_TPCON_USERDEF3 , SSF_TPCON_USERDEF4 , SSF_TPCON_USERDEF5 FROM PS_TP_CONTRACT WHERE TP_STATUS = 'A' AND TP_CON_TYPE = 'T' AND TP_CON_LAST_COR_DT > %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_SF_NONVW

2 TP_CONTRACT_FROM Character(25) VARCHAR2(25) NOT NULL Contract Num From

Prompt Table: TP_CONTRCT_SRCH

3 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
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
6 STRM Character(4) VARCHAR2(4) NOT NULL Term
7 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List
8 SSF_TPCON_USERDEF1 Character(50) VARCHAR2(50) NOT NULL Third Party Contract User Defined Field 1.
9 SSF_TPCON_USERDEF2 Character(50) VARCHAR2(50) NOT NULL Third Party Contract User Defined Field 2.
10 SSF_TPCON_USERDEF3 Character(50) VARCHAR2(50) NOT NULL Third Party Contract User Defined Field 3.
11 SSF_TPCON_USERDEF4 Character(50) VARCHAR2(50) NOT NULL Third Party Contract User Defined Field 4.
12 SSF_TPCON_USERDEF5 Character(50) VARCHAR2(50) NOT NULL Third Party Contract User Defined Field 5.