EMPLIDPrompt Table: PERSON
DEPENDENT_BENEF01=default
Default Value: 01
Prompt Table: DEPENDENT_VW
VACCINE_DT_BRAVACCINE_DOSE_BRA1=First
2=Second
3=Third
R=Reinforcement
Default Value: 1
VACCINATION_BRA(SQL Table) |
Index Back |
|---|---|
Vaccination DataVaccination Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | DEPENDENT_BENEF |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Default Value: 01 Prompt Table: DEPENDENT_VW |
| 3 | VACCINE_DT_BRA |
Date(10) | DATE NOT NULL | Vaccination Data: Vaccine Date |
| 4 | VACCINE_DOSE_BRA |
Character(1) | VARCHAR2(1) NOT NULL |
Vaccination Data:
Vaccine Dose first, second, third or reinforcement
1=First 2=Second 3=Third R=Reinforcement Default Value: 1 |
| 5 | VACCINE_TYPE_BRA | Character(20) | VARCHAR2(20) NOT NULL | Vaccination Data: Vaccine Type |