GPS_MSG_OUT_VW

(SQL Table)
Index Back

GPS outgoing messages

Empty table, used for display outgoing messages during clean-up phase.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_HR.SETID

Prompt Table: SET_VLD_HR_02

2 YEAR Character(4) VARCHAR2(4) NOT NULL Character field to represent a year
3 GPS_POST_PLN_TYPE Character(1) VARCHAR2(1) NOT NULL Post Plan TYpe
0=Base Plan
1=1. Amendment Plan
2=2. Amendment Plan
3=3. Amendment Plan
4=4. Amendment Plan

Default Value: 0

4 GPS_ROWID Character(45) VARCHAR2(45) NOT NULL RowID, a condensed version of the key fields of a budgeting system
5 GPS_GRADE Character(8) VARCHAR2(8) NOT NULL Salary Grade.
6 GPS_RANK Character(15) VARCHAR2(15) NOT NULL Rank for GPS
7 GPS_POST_TYPE Character(3) VARCHAR2(3) NOT NULL Post Type
AND=Other (Civil Service)
ANE=Other (Employee)
ANG=Public Sector Employee
ANW=Civil Servant on Recall
AZU=Apprentice
BEA=Civil Servant
ERE=Replacement Post (Employee)
ERS=Replacement Post (Civil Serv.)
LEB=Empty Post (Civil Service)
LEE=Empty Post (Employee)
8 GPS_ACTION Character(8) VARCHAR2(8) NOT NULL Action as executed on GPS Post

Default Value: ADD

Prompt Table: GPS_ACTION_TBL

9 SEQUENCE Number(2,0) SMALLINT NOT NULL Chartfield Sequence

Default Value: 1

10 GPS_DEPT_TGT Character(10) VARCHAR2(10) NOT NULL Target department

Prompt Table: DEPT_TBL

11 GPS_FRACTION Number(9,2) DECIMAL(8,2) NOT NULL GPS Fraction

Default Value: 1

12 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Default Value: A

13 GPS_NUMBER Number(6,0) INTEGER NOT NULL GPS Amount of Posts to create

Default Value: 0

14 GPS_ROWID_TGT Character(45) VARCHAR2(45) NOT NULL RowID, a condensed version of the key fields of a budgeting system
15 GPS_POST_TYPE_TGT Character(3) VARCHAR2(3) NOT NULL Post Type
AND=Other (Civil Service)
ANE=Other (Employee)
ANG=Public Sector Employee
ANW=Civil Servant on Recall
AZU=Apprentice
BEA=Civil Servant
ERE=Replacement Post (Employee)
ERS=Replacement Post (Civil Servi)
LEB=Empty Post (Civil Service)
LEE=Empty Post (Employee)
16 GPS_SETID_TGT Character(5) VARCHAR2(5) NOT NULL GPS Target SETID

Default Value: OPR_DEF_TBL_HR.SETID

Prompt Table: SET_VLD_HR_05

17 GRADE_TGT Character(3) VARCHAR2(3) NOT NULL GPS Grade Target

Prompt Table: SAL_GRADE_TBL

18 GPS_RANK_TGT Character(15) VARCHAR2(15) NOT NULL GPS Rank Target
19 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
20 DESCR10 Character(10) VARCHAR2(10) NOT NULL Description field of length 10