SSF_TP_CONT_AET (SQL Table)	Index Back
Payment Plan State Rec Payment Plan State Record

SSF_TP_CONT_AET

(SQL Table)

Payment Plan State Rec

Payment Plan State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 SCCPS_POP_SEL Character(1) VARCHAR2(1) NOT NULL Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.
Y/N Table Edit
Default Value: Y

5 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool
Prompt Table: SCCPS_TOOL_VW

6 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection
Prompt Table: %EDITTABLE

7 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context
Prompt Table: SCCPS_CNTXT_VW

8 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

10 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name

11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

12 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

14 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

15 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr

16 SERVICE_IMPACT Character(5) VARCHAR2(5) NOT NULL Service Impact

17 TP_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Active
C=Cancelled
H=Hold
I=Inactive
U=Not Posted

18 TP_CON_NUM_PAYMENT Number(3,0) SMALLINT NOT NULL Number Of Payments

19 TP_CAP_STUDENT Number(15,2) DECIMAL(14,2) NOT NULL Third Party Student Maximum

20 TP_MAX_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Maximum Amount

21 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

22 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	SCCPS_POP_SEL	Character(1)	VARCHAR2(1) NOT NULL	Population Selection checkbox - used to incidate on run controls that pop selection was selected for use. Y/N Table Edit Default Value: Y
5	SCCPS_TOOL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Tool ID - the unique key for a pop select tool Prompt Table: SCCPS_TOOL_VW
6	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection Prompt Table: %EDITTABLE
7	SCCPS_CNTXT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Context ID - the unique key that identifies the pop selection context Prompt Table: SCCPS_CNTXT_VW
8	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
9	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
10	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
15	REF1_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Reference Nbr
16	SERVICE_IMPACT	Character(5)	VARCHAR2(5) NOT NULL	Service Impact
17	TP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contract Status A=Active C=Cancelled H=Hold I=Inactive U=Not Posted
18	TP_CON_NUM_PAYMENT	Number(3,0)	SMALLINT NOT NULL	Number Of Payments
19	TP_CAP_STUDENT	Number(15,2)	DECIMAL(14,2) NOT NULL	Third Party Student Maximum
20	TP_MAX_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Maximum Amount
21	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
22	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.