EMPL_RCRDS_VW7

(SQL View)
 Index Back

Change/Delete EMPLID-Like Flds

The system uses EMPL_RCRDS_VIEW records are used during the process of changing or deleting an employee from the database. EMPL_RCRDS_VIEW processes records keyed by EMPLID. EMPL_RCRDS_VW2 processes records containing ID-like fields that are not named EMPLID, such as SUPERVISOR_ID. EMPL_RCRDS_VW3 processes records with EMPLID in a subrecord. EMPL_RCRDS_VW4 processes records with EMPLID-like fields in a subrecord. EMPL_RCRDS_VW5 processes records with EMPLID in a sub-sub record. EMPL_RCRDS_VW6 processes records with EMPLID-like fields in a sub-sub record EMPL_RCRDS_VW7 processes Campus Solutions records containing ID-like fields that are not named EMPLID, such as SUPERVISOR_ID.

SELECT A.RECNAME ,A.FIELDNAME ,B.SQLTABLENAME FROM PSRECFIELD A , PSRECDEFN B WHERE A.RECNAME = B.RECNAME AND B.RECTYPE = 0 AND B.OBJECTOWNERID LIKE 'S%' AND (A.FIELDNAME IN ('ADVISOR1_ID', 'ADVISOR2_ID', 'ADVISOR_ID', 'ALTER_EMPLID', 'ASSOC_ID', 'AUTHOR_ID', 'AV_ID', 'AV_ORIG_DNR_ID', 'AV_TRIB_ID', 'BEGIN_EMPLID', 'BORR_EMPLID', 'CMNT_ID', 'COMM_ID', 'COMPLETED_ID', 'CONTRACT_EMPLID', 'COORDINATOR_ID', 'COORDNTR_OTR_ID', 'COUNSELOR', 'EMPLID_RELATED', 'EMP_ORG_ID', 'END_EMPLID', 'END_EMPLID2', 'EVALUATOR_ID', 'EVENT_MANAGER', 'FROM_ID', 'INSTRUCTOR_ID', 'INTERVIEWER', 'LN_REFUND_EMPLID', 'MANAGER_ID', 'OPR_EMPLID', 'PG_MR_STDNT_ID', 'PG_YTD_REQ_ORIG_ID', 'PLACED_PERSON_ID', 'PRSP_MGR_ID', 'RCG_EMPLID1', 'RCG_EMPLID2', 'RCG_EMPLID3', 'RCG_EMPLID4', 'RECOG_ID', 'RECOMMENDER_ID', 'RECRUITER_ID', 'REFUND_EMPLID', 'RESPONSIBLE_ID', 'RSPL_ID', 'SEV_DEP_EMPLID', 'SEV_DSO_EMPLID', 'SEV_RO_EMPLID', 'SLCTR_ID', 'SPONSOR_EMPLID', 'SPOUSE_ID', 'SSF_SL_EMPLID', 'STAFF_ID', 'START_EMPLID', 'STATUS_CHANGE_ID', 'SUPERVISOR_ID', 'TO_ID', 'VOL_MGR_ID') OR (A.FIELDNAME = 'COMMON_ID' AND A.RECNAME NOT IN ( SELECT RECNAME FROM PSRECFIELD WHERE FIELDNAME = 'SA_ID_TYPE')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 SQLTABLENAME Character(18) VARCHAR2(18) NOT NULL SQL Table Name