INSTALLATION_HR(SQL Table) |
Index Back |
|---|---|
HR Installation RecordThis record is for HR installation fields that are being updated in either online transactions or batch processing. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | CAR_LAST | Number(7,0) | INTEGER NOT NULL | Last Car Nbr Assigned |
| 3 | CLAIM_NBR_LAST | Number(8,0) | INTEGER NOT NULL | Last H/S Claim Nbr Assigned |
| 4 | DEMAND_ID_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last Demand ID Assigned |
| 5 | EMPLID_LAST_EMPL | Number(10,0) | DECIMAL(10) NOT NULL | Last Employee ID Assigned |
| 6 | GRIEVANCE_NBR_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last Grievance Number Assigned |
| 7 | INCIDENT_NBR_LAST | Number(8,0) | INTEGER NOT NULL | Last Incident # Assignend |
| 8 | ILL_NBR_LAST_GER | Number(8,0) | INTEGER NOT NULL | Last Illness Nbr Assigned |
| 9 | ILL_NBR_LAST_NLD | Number(5,0) | INTEGER NOT NULL | Last Illness Report # Assigned |
| 10 | LAST_OSHA_CASE_NBR | Number(5,0) | INTEGER NOT NULL | Last OSHA Case Nbr Assigned |
| 11 | LAST_SP_ID_ASSIGN | Number(11,0) | DECIMAL(11) NOT NULL | Last Succession Plan ID Assigned |
| 12 | NON_EMPLOYEE_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last H&S Non-Employee ID Assgn |
| 13 | OWS_SEQ_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Oracle Workforce Scheduling Event Sequence |
| 14 | POSN_NBR_LAST | Number(8,0) | INTEGER NOT NULL | Last Position Number Assigned |
| 15 | TBH_SEQ_LAST | Number(12,0) | DECIMAL(12) NOT NULL | Template Sequence |
| 16 | TEMP_ASSGN_ID_LAST | Number(8,0) | INTEGER NOT NULL | This field holds the last Temporary Assignment number used. |
| 17 | DISP_PHOTO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display Photo flag used to indicate whether Photo to be displayed or not.
Y/N Table Edit Default Value: Y |
| 18 | DISP_PHOTO_SS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display Photo on Self Service flag to indicate whether Photo to be displayed on Self Service pages or not.
Y/N Table Edit Default Value: Y |
| 19 | ADD_PHOTO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow User to Upload Photo
Y/N Table Edit Default Value: N |
| 20 | UPLOAD_PHOTO_SIZE | Number(4,0) | SMALLINT NOT NULL | Maximun Photo Upload Size |
| 21 | LAST_MATRIX_ID | Number(10,0) | DECIMAL(10) NOT NULL | Last Matrix ID Assigned |
| 22 | HCSCM_MASK_YN | Character(1) | VARCHAR2(1) NOT NULL |
Enable Masking
N=NO Y=YES |
| 23 | HSC_BNKAC_ENABLE | Character(1) | VARCHAR2(1) NOT NULL |
Enable Bank Account Encryption
Y/N Table Edit Default Value: N |
| 24 | GENDER_IDNT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Gender Identity Flag
Y/N Table Edit Default Value: N |
| 25 | HR_GSS_MLTI_TRN | Character(1) | VARCHAR2(1) NOT NULL |
Gender Identity Flag
Y/N Table Edit Default Value: N |
| 26 | HRRC_ENABLED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Recognition installation flag
Y/N Table Edit Default Value: Y |
| 27 | HRRC_ENBL_CMNT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Comments for Recognition installation flag
Y/N Table Edit Default Value: Y |
| 28 | RC_RECOG_ID_LAST | Number(8,0) | INTEGER NOT NULL | Last Recognition ID Assigned |