RECRUIT_CATPrompt Table: FO_RECR_SRC_VW
RECRUIT_SRCDefault Value: OPR_DEF_TBL.SETID
Prompt Table: SETID_TBL
FO_RCT_CTSRC_VW(SQL View) |
Index Back |
|---|
| SELECT A.RECRUIT_CAT , A.RECRUIT_SRC , A.SETID , A.DESCR , A.DESCRSHORT FROM PS_FO_RECR_CATSRC A , PS_FO_RCRT_SRC_VW B WHERE A.RECRUIT_CAT = B.RECRUIT_CAT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECRUIT_CAT |
Character(6) | VARCHAR2(6) NOT NULL |
Recruit Source Category
Prompt Table: FO_RECR_SRC_VW |
| 2 | RECRUIT_SRC |
Character(6) | VARCHAR2(6) NOT NULL | Recruiting Source |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL.SETID Prompt Table: SETID_TBL |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |