Table Name | AEEPF |
Long Name | Meeting Participants |
Description | Each meeting held on behalf of a given child can have multiple participants. As the role of participants may vary from meeting to meeting, this file allows for the recording of both the participants role and the function they fulfilled during the meeting. In addition, this file records the information associated with each participant's agency. |
Prefix | EP |
Field Name | Length | Type | Description | Comments |
---|---|---|---|---|
ep_aeajob | 3 | char | Position (Job Title) | |
ep_agency | 4 | char | Agency Code | |
ep_chid | 15 | char | Child ID | Key Field - links to child file |
ep_date | 8 | datetime | Meeting Date | |
ep_dept | 3 | char | Department | |
ep_jobcode | 3 | char | Meeting Position | |
ep_name | 45 | char | Participant Name | |
ep_pagency | 4 | char | Agency | |
ep_ssn | 9 | char | Social Security Number | |
ep_typcode | 5 | char | Meeting Type | |
ep_udate | 8 | datetime | Record Updated (Date) | |
ep_uid | 9 | char | Record Updated (User ID) | |
ep_utime | 8 | char | Record Updated (Time) | |
ep_keymef | 10 | char | Unique Meeting ID | |
ep_keyepf | 10 | char | AEEPF KEY |