GVT_AUTO_SEC_VW(SQL View) |
Index Back |
|---|---|
Sec view federal Auto Actions |
| SELECT DISTINCT %Sql(SCRTY_SEL_PKEY_USF,OPR,SEC) , AC.GVT_AUTO_ACTN_TYPE , AC.GVT_ACTION_DT FROM %Sql(SCRTY_PERUSF_FROM) , PS_GVT_AUTO_ACTN AC WHERE %Sql(SCRTY_WHERE_PPLUSF) AND AC.EMPLID = SEC.EMPLID AND AC.EMPL_RCD = SEC.EMPL_RCD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 5 | GVT_AUTO_ACTN_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Automatic Action Type
PS=SES Probation Termination PT=Standard Probation Termination PV=Super. Probation Termination TC=Career Cond. Tenure Conversion TD=Career Cond. TC Exceptions TE=Career TC Exception TV=Career Tenure Conversion WB=WGI W/O Min. Performance WG=Within Grade Increase WM=Manual WGI WN=WGI Postponed or Denied WR=Retro-active WGI |
| 6 | GVT_ACTION_DT |
Date(10) | DATE NOT NULL | Action Date |