SSR_HE_MSTI_PRO (SQL Table)	Index Back
HESA Institution Process HESA Submitted Institution Process

SSR_HE_MSTI_PRO

(SQL Table)

HESA Institution Process

HESA Submitted Institution Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

2 SSR_HE_RET_TYPE Character(10) VARCHAR2(10) NOT NULL Return Type
Prompt Table: SSR_HE_RETURNS

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 NUMBER20 Number(20,0) DECIMAL(20) NOT NULL Number

6 INSERT_FL Character(1) VARCHAR2(1) NOT NULL Insert Flag
Y/N Table Edit
Default Value: N

7 DELETE_FL Character(1) VARCHAR2(1) NOT NULL Delete Flag
Y/N Table Edit
Default Value: N

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

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

10 RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success

11 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	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	SSR_HE_RET_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Return Type Prompt Table: SSR_HE_RETURNS
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	NUMBER20	Number(20,0)	DECIMAL(20) NOT NULL	Number
6	INSERT_FL	Character(1)	VARCHAR2(1) NOT NULL	Insert Flag Y/N Table Edit Default Value: N
7	DELETE_FL	Character(1)	VARCHAR2(1) NOT NULL	Delete Flag Y/N Table Edit Default Value: N
8	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
10	RUNSTATUS	Character(2)	VARCHAR2(2) NOT NULL	Process Scheduler Process Run Status 1=Cancel 10=Not Successful 11=Posted 12=Unable to post 13=Resend 14=Posting 15=Content Generated 16=Pending 17=Success With Warning 18=Blocked 19=Restart 2=Delete 3=Error 4=Hold 5=Queued 6=Initiated 7=Processing 8=Cancelled 9=Success
11	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.