GVT_PRIO_PLCMNT_CDPrompt Table: HRS_G_PR_PL_TBL
EFFDTHRS_G_JO_TYPEI=Internal
M=Merit Promotion
O=Open Competition
1=None
2=Must Consider
3=Must Select
Default Value: 1
HRS_G_PRPL_SL_I(SQL View) |
Index Back |
|---|---|
Priority Placement Sel IntfcInterface for priority placement selection. |
| SELECT A.GVT_PRIO_PLCMNT_CD ,A.EFFDT ,A.HRS_G_JO_TYPE ,A.GVT_RQSN_SEL_CRITE ,%subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_G_PR_PL_SEL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_PRIO_PLCMNT_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Priority Placement Code
Prompt Table: HRS_G_PR_PL_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | HRS_G_JO_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Federal job requisition type
I=Internal M=Merit Promotion O=Open Competition |
| 4 | GVT_RQSN_SEL_CRITE | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening Selection Criteria
1=None 2=Must Consider 3=Must Select Default Value: 1 |
| 5 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 6 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 7 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 8 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |