GPS_MSG_OUT_VW(SQL Table) |
Index Back |
---|---|
GPS outgoing messagesEmpty 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 |