ACA_ALE_MEMBEREFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: ACA_ALE_GRP
ACA_ALE_TBL(SQL Table) |
Index Back |
|---|---|
ALE Member -Aggregated ALE GrpALE Member linked to Aggregated Group ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACA_ALE_MEMBER |
Character(3) | VARCHAR2(3) NOT NULL | Used to contain value of ALE Member name |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | ACA_DESCR | Character(75) | VARCHAR2(75) NOT NULL | Name |
| 5 | ACA_ALE_GRP_ID | Character(3) | VARCHAR2(3) NOT NULL |
ACA Aggregated ALE Group ID
Prompt Table: ACA_ALE_GRP |
| 6 | CONTACT_PHONE_ACA | Character(24) | VARCHAR2(24) NOT NULL | Used for contact phone for ACA |
| 7 | ACA_XMIT_CTL_CODE | Character(10) | VARCHAR2(10) NOT NULL | Transmitter Control Code |