EMPL_RCRDS_VW2(SQL View) |
Index Back |
|---|---|
Change/Delete EMPLID-Like FldsThe 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 |
| SELECT A.RECNAME ,A.FIELDNAME ,B.SQLTABLENAME FROM PSRECFIELD A , PSRECDEFN B WHERE A.RECNAME = B.RECNAME AND A.EDITTABLE IN ('PERSON','TRN_CRS_INSTRCT','PERS_DTA_EMP_VW','PERSON_NAME', 'REVIEWER_NM_VW', 'WORKER_PROMPT', 'HRS_ACT_PERS_I', 'HR_ACTIVE_DVW', 'TL_SUPRVSR_VW', 'HCR_SUP_ID_VW', 'HCR_SUP_ID_DVW') AND B.RECTYPE = 0 AND A.FIELDNAME <> 'EMPLID' |
| # | 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 |