RECNAMEEMPL_RCRDS_VW6(SQL View) |
Index Back |
|---|---|
Change/Delete EMPLID FieldsThe 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 , RF3.FIELDNAME , RD1.SQLTABLENAME , RF2.RECNAME , RF2.FIELDNAME FROM PSRECDEFN RD1 , PSRECFIELD RF1 , PSRECFIELD RF2 , PSRECFIELD RF3 WHERE RD1.RECNAME = RF1.RECNAME AND RD1.RECTYPE = 0 AND RF2.RECNAME = RF1.FIELDNAME AND RF1.SUBRECORD = 'Y' AND RF3.RECNAME = RF2.FIELDNAME AND RF2.SUBRECORD = 'Y' AND RF3.FIELDNAME <> 'EMPLID' AND RF3.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 |
| 5 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |