| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
CHAR1_DEF |
Character(1) |
VARCHAR2(1) NOT NULL |
Monthly Default Value
Default Value: N
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 5 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 6 |
ACA_DAT_EXTRACT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Extract ID for the ACA data
|
| 7 |
ACA_ALE_MEMBER |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to contain value of ALE Member name
|
| 8 |
ACA_CALENDAR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
1094-C/1095-C Calendar Year
|
| 9 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 10 |
ACA_DATA_EXTR_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Extract Run Option
A=Extract ALE Employer Data
C=Remove Extracted Data
E=Extract ACA Employee Data
F=Finalize For Transmittal
I=Extract All Transmittal Data
Q=Extract Employees by Query
U=Un Finalize Extracted Data
|
| 11 |
PARTIC_LIST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
List indicator for participants
|
| 12 |
EFFDT_FROM |
Date(10) |
DATE |
Effective Date From
|
| 13 |
EFFDT_TO |
Date(10) |
DATE |
Effective Date To
|
| 14 |
CHAR4_DEF |
Character(4) |
VARCHAR2(4) NOT NULL |
Monthly Default Value
|
| 15 |
CHAR20_DEF |
Character(20) |
VARCHAR2(20) NOT NULL |
All Months indicator
|
| 16 |
COUNT12_DEF |
Number(12,0) |
DECIMAL(12) NOT NULL |
AUS WGEA counts
|
| 17 |
AMOUNT2_DEF |
Signed Number(21,2) |
DECIMAL(19,2) NOT NULL |
amount value used for ACA processing
|
| 18 |
AMOUNT2_HI_VALUE |
Signed Number(21,2) |
DECIMAL(19,2) NOT NULL |
amount value used for ACA processing
Default Value: 99999.99
|
| 19 |
ASOF_DAY_INMONTH_C |
Character(4) |
VARCHAR2(4) NOT NULL |
Day month values used for ACA processing
D1MN=First Day of the Month
LDMN=Last Day of the Month
MMDD=Specified Day
|
| 20 |
ACA_AS_OF_DD_CMN |
Number(2,0) |
SMALLINT NOT NULL |
As of Day
|
| 21 |
ACA_MO_ASOFDT_CMN |
Date(10) |
DATE |
Common Monthly As of Date
|
| 22 |
ASOF_DAY_INMONTH |
Character(4) |
VARCHAR2(4) NOT NULL |
Day month values used for ACA processing
D1MN=First Day
LDMN=Last Day
MMDD=Specified Day
|
| 23 |
ACA_AS_OF_DD |
Number(2,0) |
SMALLINT NOT NULL |
As of Day
|
| 24 |
ACA_MO_ASOFDT_SPC |
Date(10) |
DATE |
Specific Monthly As of Date
|
| 25 |
ACA_FIRST_DAY_YEAR |
Date(10) |
DATE |
ACA First Day of Year
|
| 26 |
ACA_LAST_DAY_YEAR |
Date(10) |
DATE |
Common Monthly As of Date
|
| 27 |
ACA_BEGIN_MONTH |
Date(10) |
DATE |
Beginning of Month
|
| 28 |
ACA_END_MONTH |
Date(10) |
DATE |
End of Month
|
| 29 |
ACA_EMP_DATA_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
ID for the employee ACA data
CDS1=Offer of Coverage Code
CDS2=SafeHarbor & OtherRelief Codes
HRZP=HRA Zip Code
LCST=Self-Only Lowest Premium Cost
LCSV=Self Low Cost Base Benefits
LCSX=Self Low Cost BA No Credit
LCSY=Self Low Cost BA With Credit
OHRA=HRA Silver Plan
OHRB=HRA Employer Contrib Base Ben
OHRD=HRA Employer Contrib Ben Admin
OHRR=HRA Empl Required Contribution
|
| 30 |
ACA_DEP_DATA_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
ID used for the dependent ACA data
CVRG=Months of Coverage
|
| 31 |
ACA_UPD_FIELD |
Character(30) |
VARCHAR2(30) NOT NULL |
Update Field
|
| 32 |
ACA_REF_FIELD |
Character(30) |
VARCHAR2(30) NOT NULL |
Referenced Field
|
| 33 |
ACA_SQLID |
Character(30) |
VARCHAR2(30) NOT NULL |
SQLID Criteria
|
| 34 |
ACA_SQLID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQLID Update
|
| 35 |
MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Month
|
| 36 |
ACA_ALE_DATA_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
ALE Member Monthly Data
AGID=Aggregated Group Indicator
EMCT=Total Employee Count
FTCT=Full-Time Employee Count
MECC=MEC Employee Offer Count
MECF=Minimum Essential Coverage ID
TRID=Sec 4980H Transition Relief ID
|
| 37 |
QRYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name
|
| 38 |
ASOFDATE |
Date(10) |
DATE |
As of Date
|
| 39 |
ACA_UPDATE_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Update All Flag
|
| 40 |
P_PRCSINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 41 |
TABLENAME |
Character(32) |
VARCHAR2(32) NOT NULL |
|
| 42 |
NUM_ROWS |
Number(18,0) |
DECIMAL(18) NOT NULL |
Number of Rows
|