EMPL_RCRDS_VW4(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 RD1.RECNAME , RF2.FIELDNAME , RD1.SQLTABLENAME , RF2.RECNAME FROM PSRECDEFN RD1 , PSRECFIELD RF1 , PSRECFIELD RF2 WHERE RD1.RECNAME = RF1.RECNAME AND RD1.RECTYPE = 0 AND RF2.RECNAME = RF1.FIELDNAME AND RF1.SUBRECORD = 'Y' AND RF2.FIELDNAME <> 'EMPLID' AND (RF2.EDITTABLE IN ('PERSON','TRN_CRS_INSTRCT','PERS_DTA_EMP_VW','PERSON_NAME', 'REVIEWER_NM_VW', 'WORKER_PROMPT') ) |
| # | 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 |
| 4 | SUBRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Subrecord (Table) Name |