HRS_JOBI_DEL_VW(SQL View) |
Index Back |
---|---|
Internal Search Indexing ViewThis record is used in the internal search indexing process to collect information for the Verity Index for deletes. |
SELECT A.HRS_JOB_OPENING_ID ,%Substring(B.FIELDVALUE, 1, 1) FROM PS_HRS_JOBINDX_CTL A , PSXLATITEM B WHERE B.FIELDNAME = 'HRS_JO_PST_TYPE' AND (B.FIELDVALUE = 'I' OR B.FIELDVALUE = 'E') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
2 | HRS_JO_PST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening Posting Type
C=Contingent Workforce E=External Posting I=Internal Posting L=Labor Office R=Recruitment |