|
SELECT FIELDNAME FROM PSRECFIELD WHERE RECNAME = 'HRS_JO_I' AND FIELDNAME IN ('HRS_JOB_OPENING_ID','HRS_JO_TYPE','HRS_RCRT_TMPL_ID','STATUS_DT','STATUS_CODE','OPEN_DT','CLOSE_DT','POSITION_NBR','BUSINESS_UNIT','JOBCODE','DEPTID','LOCATION','COMPANY','AUTHORIZATION_DT','REQ_NEW_POSN','JOB_POSTING_ID','OPENINGS_CNT','OPENINGS_TARGET','REG_TEMP','BEGIN_DT','END_DT','FULL_PART_TIME','STD_HOURS','STD_HRS_FREQUENCY','SHIFT','SAL_ADMIN_PLAN','REG_REGION','WC_COUNCIL_ID','ENCUMB_DT_INDC','PROJECTED_FILL_DT','SETID_DEPT','RECRUITMT_OPEN_DT','RECRUITMT_CLOSE_DT','APPROVAL_STATUS','DESIRED_START_DT','TRAVELLING','TRAVEL_PERCENT')
|
FIELDNAME