COUNTRYPrompt Table: GP_WC_CNTRY_VW
GP_WC_ACTION_IDH=Hire
R=Rehire
T=Termination
GP_WC_ACT_VW(SQL View) |
Index Back |
|---|---|
Action Item Search PageAction Item Search Page |
| SELECT country , gp_wc_action_id FROM PS_GP_WC_CNTRY_ACT WHERE country <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_WC_CNTRY_VW |
| 2 | GP_WC_ACTION_ID |
Character(1) | VARCHAR2(1) NOT NULL |
Action ID
H=Hire R=Rehire T=Termination |