GPS_POST_EE_VW(SQL Table) |
Index Back |
|---|---|
GPS Employee ViewRetrieves all employees associated with a particula post |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
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 |
| 4 | GPS_ROWID | Character(45) | VARCHAR2(45) NOT NULL | RowID, a condensed version of the key fields of a budgeting system |
| 5 | EFFDT | Date(10) | DATE | Effective Date |
| 6 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 7 | GPS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
status of row in gps_post_dtl table
A=Active B=Blocked C=Copied Post I=Inactive N=New Post O=Occupied P=Pending R=Reserved S=Temporarily Blocked T=Terminated U=Cut V=Vacant |
| 8 | GPS_ACTION | Character(8) | VARCHAR2(8) NOT NULL | Action as executed on GPS Post |
| 9 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 10 | GPS_POST_ID | Character(8) | VARCHAR2(8) NOT NULL | GPS post id |
| 11 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 12 | GPS_FRACTION | Number(9,2) | DECIMAL(8,2) NOT NULL | GPS Fraction |
| 13 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 14 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 15 | GPS_FTE | Number(4,2) | DECIMAL(3,2) NOT NULL | GPS This field represent Full Time Equivalence |
| 16 | GPS_PLN_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Plan Status
ACTV=Active Plan APPR=Approved Plan CHNG=Changed CLNP=Plan in Clean-Up Phase CLSD=Plan Closed COPY=Copied Plan DENY=Denied DONE=Clean-Up Done NEW=New Plan |
| 17 | GPS_BDG_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL |
Budgeting System
D=Doppik K=Kameralistik O=Other |
| 18 | GPS_BDG_ORG1 | Character(8) | VARCHAR2(8) NOT NULL |
Budgeting Organization
Prompt Table: GPS_ORG_DVW |
| 19 | GPS_BDG_ORG2 | Character(8) | VARCHAR2(8) NOT NULL |
Budgeting Organization
Prompt Table: %EDITTABLE |
| 20 | GPS_BDG_ORG3 | Character(8) | VARCHAR2(8) NOT NULL |
Budgeting Organization
Prompt Table: %EDITTABLE2 |
| 21 | GPS_BDG_ORG4 | Character(8) | VARCHAR2(8) NOT NULL |
Budgeting Organization
Prompt Table: %EDITTABLE3 |
| 22 | GPS_BDG_ORG5 | Character(8) | VARCHAR2(8) NOT NULL |
Budgeting Organization
Prompt Table: %EDITTABLE4 |
| 23 | GPS_GRADE | Character(8) | VARCHAR2(8) NOT NULL |
Salary Grade.
Prompt Table: GPS_POST_GRD_VW |
| 24 | GPS_RANK | Character(15) | VARCHAR2(15) NOT NULL | Rank for GPS |
| 25 | 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) |
| 26 | GPS_SRCH_CHKBOX | Character(1) | VARCHAR2(1) NOT NULL | Select |