HRS_APPL_COV_VW(SQL View) |
Index Back |
|---|---|
Application Cover Letter ViewAttachments with processing type of Cover Letter that are specific to an application. |
| SELECT RCM.HRS_PERSON_ID , RCM.HRS_RCMNT_ID , RCM.HRS_PROFILE_SEQ , 1 , ATC.DESCR , ' ' , ATC.ATTACHSYSFILENAME , ATC.ATTACHUSERFILE , ' ' , ATC.DESCR , RCM.HRS_JOB_OPENING_ID , ATT.ATTACH_TYPE_CD , 0 , ' ' FROM PS_HRS_RCMNT RCM , PS_HRS_APP_ATTACH ATC , PS_HRS_ATT_TYP_TBL ATT WHERE RCM.HRS_PERSON_ID = ATC.HRS_PERSON_ID AND RCM.HRS_PROFILE_SEQ = ATC.HRS_PROFILE_SEQ AND ATC.ATTACH_TYPE_CD = ATT.ATTACH_TYPE_CD AND ATT.ATTACH_PROCESS_TYP = 'COV' AND ATT.STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | HRS_RCMNT_ID |
Number(15,0) | DECIMAL(15) NOT NULL | App Tracking Recruitment ID |
| 3 | HRS_PROFILE_SEQ | Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 4 | ATTACH_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Attachment Sequence Number |
| 5 | HRS_RESUME_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Profile ID |
| 6 | 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 |
| 7 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 8 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 9 | RESUME_TEXT | Long Character | CLOB | Resume text |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 12 | ATTACH_TYPE_CD | Character(3) | VARCHAR2(3) NOT NULL | Attachment Type Code |
| 13 | HRS_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 14 | HRS_ATTACHFILENAME | Character(128) | VARCHAR2(128) NOT NULL | New File Name |