EMPLIDEMPL_RCDEXAM_DTEXAM_TYPE_BRAH=Hire
P=Professional Driver
T=Termination
Prompt Table: %EDITTABLE
Prompt Table: LAB_PROVID_BRA
0=RMS
1=CRM
2=CRO
Default Value: BRA
Prompt Table: STATE_TBL
Y/N Table Edit
Default Value: N
EMP_DRUG_TS_BRA(SQL Table) |
Index Back |
|---|---|
Employee's Drug TestEmployee's drug test to be used in CAGED electronic file as of 2017. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EXAM_DT |
Date(10) | DATE | Exam Date |
| 4 | EXAM_TYPE_BRA |
Character(1) | VARCHAR2(1) NOT NULL |
Exam type.
H=Hire P=Professional Driver T=Termination |
| 5 | EXAM_NBR_BRA | Character(17) | VARCHAR2(17) NOT NULL | Drug exam number. |
| 6 | NON_EMPLOYEE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Non-Employee ID
Prompt Table: %EDITTABLE |
| 7 | LAB_ID_BRA | Character(3) | VARCHAR2(3) NOT NULL |
Laboratory provider ID for driver's drug testing.
Prompt Table: LAB_PROVID_BRA |
| 8 | PHYSICIAN_NAME_BRA | Character(70) | VARCHAR2(70) NOT NULL | Physician Name BRA field. |
| 9 | ORG_STAT_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Organ Statutory Information
0=RMS 1=CRM 2=CRO |
| 10 | MED_CRM_BRA | Character(15) | VARCHAR2(15) NOT NULL | Medical Certication Register. |
| 11 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: BRA |
| 12 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 13 | LABORATORY_BRA | Character(100) | VARCHAR2(100) NOT NULL | Laboratory Brazil. |
| 14 | LAB_CNPJ_BRA | Character(14) | VARCHAR2(14) NOT NULL | Laboratory Provider CNPJ |
| 15 | EMPL_DRUG_REF_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Indicator of whether the employee refused to take the drug test or not at the termination.
Y/N Table Edit Default Value: N |
| 16 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |