HR_PER_REL_CFG(SQL Table) |
Index Back |
|---|---|
Configuration RecordJob data Configuration Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_PER_REL_CONF | Character(1) | VARCHAR2(1) NOT NULL | Fluid flag for job data setup |
| 2 | HR_EMP_RCD_AUTO | Character(1) | VARCHAR2(1) NOT NULL | Assign Employee Record |
| 3 | HR_EMP_AUTO_ASN | Character(1) | VARCHAR2(1) NOT NULL | Fluid flag for job data setup |
| 4 | HR_OVR_AUTO_ASGN | Character(1) | VARCHAR2(1) NOT NULL | Fluid flag for job data setup |
| 5 | HR_NAME_ATTCH_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Enable/Disable Name attachment flag
Y/N Table Edit |
| 6 | HR_ADDR_ATTCH_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Enable/Disable Address attachment flag
Y/N Table Edit |
| 7 | HR_NID_ATTCH_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Enable/Disable National ID attachment flag
Y/N Table Edit |
| 8 | HR_VTRN_ATTCH_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Enable/Disable Veteran attachment flag
N=No Y=Yes Default Value: Y |
| 9 | HR_BIOGRAPHICAL | Character(1) | VARCHAR2(1) NOT NULL | Biographical |
| 10 | BCNAME_PER | Character(30) | VARCHAR2(30) NOT NULL |
Component Interface Name
Prompt Table: PSBCDEFN_VW3 |
| 11 | HR_ENA_ATT_FL | Character(1) | VARCHAR2(1) NOT NULL | Fluid flag for job data setup |
| 12 | HR_ENA_ATT_FL_CW | Character(1) | VARCHAR2(1) NOT NULL | Fluid flag for job data setup |
| 13 | HR_ENA_ATT_FL_POI | Character(1) | VARCHAR2(1) NOT NULL | Fluid flag for job data setup |
| 14 | HR_ENA_APRVL | Character(1) | VARCHAR2(1) NOT NULL | Fluid flag for job data setup |
| 15 | HR_ENA_APRVL_CW | Character(1) | VARCHAR2(1) NOT NULL | Fluid flag for job data setup |
| 16 | HR_ENA_APRVL_POI | Character(1) | VARCHAR2(1) NOT NULL | Fluid flag for job data setup |
| 17 | BCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Component Name (see PSBCDEFN).
Prompt Table: PSBCDEFN_VW3 |
| 18 | BCNAME_CW | Character(30) | VARCHAR2(30) NOT NULL |
Component Interface Name
Prompt Table: PSBCDEFN_VW3 |
| 19 | BCNAME_POI | Character(30) | VARCHAR2(30) NOT NULL |
Component Interface Name
Prompt Table: PSBCDEFN_VW3 |
| 20 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: EOAW_TXN |
| 21 | EOAWPRCS_ID_CW | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: EOAW_TXN |
| 22 | EOAWPRCS_ID_POI | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: EOAW_TXN |
| 23 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGROOT_VW |
| 24 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
| 25 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSPACKAGCLAS_VW |
| 26 | APPCLASSMETHOD | Character(60) | VARCHAR2(60) NOT NULL | Application Class Method Name |