HRS_APP_RES_I(SQL View) |
Index Back |
|---|---|
Resume text InterfaceCapture Applicants Resume in ascii text format or as an attached file |
| SELECT HRS_RESUME_ID ,HRS_PERSON_ID ,HRS_RESUME_TITLE ,LANG_CD ,RESUME_TEXT ,ATTACHSYSFILENAME ,ATTACHUSERFILE FROM PS_HRS_APP_RES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_RESUME_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Resume id |
| 2 | HRS_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 3 | HRS_RESUME_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Profile ID |
| 4 | LANG_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese Prompt Table: HRS_LNG_CD_VW |
| 5 | RESUME_TEXT | Long Character | CLOB | Resume text |
| 6 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 7 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |