HRS_PERSON_IDHRS_RCMNT_IDHRS_OFF_IDSEQ_NBRA=Active
I=Inactive
001=URL
002=Attachment
003=Document Definition
004=Note
HRS_OJO_ATCU_VW(SQL View) |
Index Back |
|---|---|
Attachment Document URLsAttachment Document URLs |
| SELECT B.HRS_PERSON_ID , B.HRS_RCMNT_ID , B.HRS_OFF_ID , %subrec(HR_ATT_DD_SBR, B) FROM PS_HRS_OFF_ATCH B WHERE B.HR_ATT_TYPE = '001' |
| # | 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_OFF_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Offer ID |
| 4 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | HR_ATT_CNFG_ID | Character(18) | VARCHAR2(18) NOT NULL | Attachment Configuration |
| 6 | HR_ATT_ENT_ID | Character(18) | VARCHAR2(18) NOT NULL | Attachment Authorization Entry ID |
| 7 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Datetime |
| 8 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 9 | EMPLID_CREATOR | Character(11) | VARCHAR2(11) NOT NULL | HR Notepad: Employee ID of the person who originally created a note. |
| 10 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 11 | HR_ATT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Attachment Types
001=URL 002=Attachment 003=Document Definition 004=Note |
| 12 | HR_ATT_SUBJECT | Character(50) | VARCHAR2(50) NOT NULL | HR Notepad: Subject of note. |
| 13 | HR_ATT_NOTETEXT | Long Character(8095) | CLOB | HR Attachments: Text of note. |
| 14 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 15 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 16 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |