PSARCH_IDPSARCH_BATCHNUMHRS_JOB_OPENING_IDLANGUAGE_CDHRS_JOLNG_HST(SQL Table) |
Index Back |
|---|---|
Job Requisition CodesUse JOB_REQUISITION to record information for job requisitons such as job code, department, position ID, authorization data, status, and status dates. This data is used primarily in Recruitment. You can create only one JOB_REQUISITION record per requisition. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | POSTING_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
| 6 | GVT_RECR_OFF_RMKS | Character(254) | VARCHAR2(254) NOT NULL | Recruiting Office Remarks |
| 7 | COMMENTS | Long Character | CLOB | Comment |