ACA_SS_GDE_TMP (SQL Table)	Index Back
ACA Form Self Service ACA Self Service Guide Temporary Table. Each entry on this table corresponds to one ACA form.

ACA_SS_GDE_TMP

(SQL Table)

ACA Form Self Service

ACA Self Service Guide Temporary Table. Each entry on this table corresponds to one ACA form.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

5 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

7 ACA_CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL 1094-C/1095-C Calendar Year

8 ACA_ALE_MEM_GRP Character(3) VARCHAR2(3) NOT NULL Applicable Large Employer

9 ACA_ALE_MEMBER Character(3) VARCHAR2(3) NOT NULL Used to contain value of ALE Member name

10 ACA_FORM_TYPE Character(4) VARCHAR2(4) NOT NULL ACA Form Type. The default Value is 1095-C
1095=1095-C

11 ACA_SEQNO Number(2,0) SMALLINT NOT NULL Sequence Number

12 ACA_YE_FORM_SEQNUM Number(2,0) SMALLINT NOT NULL A sequential number to indicate the number of Form 1095-C that have been issued/generated for an employee. Initial copy will have a value of 1.

13 ACA_PROCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Process type.
C=Correction
O=Original
P=Replace Transmission
Q=Replace Submission
R=Reissue

14 ACA_FORM_ISSUE_DT Date(10) DATE This field is used in ACA Self Service Forms. It stores the date when the forms were generated.

15 ACA_FORM_VIEW_DT Date(10) DATE This field is used in ACA Self Service Year-End Forms. It stores the date that determines when the forms become viewable in Self Service.

16 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

17 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

18 ACA_YE_FILEURLID Character(30) VARCHAR2(30) NOT NULL URL ID used to store and retrieve year-end pdf forms.

19 ACA_REPORT_URL Character(254) VARCHAR2(254) NOT NULL Report URL.

20 ACA_BURST_ID Character(40) VARCHAR2(40) NOT NULL Stores the value used for bursting a PDF file into separate employee-level files.

21 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

22 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).

23 BURST_FIELDNAME Character(30) VARCHAR2(30) NOT NULL Burst Field Name

24 ACA_NOTIFY_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether notification of availability for viewing a year-end form has been sent to employee. Y - notification already sent to employee N - notification not yet sent to employee

25 ACA_FINAL_PRINT Character(1) VARCHAR2(1) NOT NULL Identifies whether final run or not.
Y/N Table Edit

26 ACA_FORM_STATUS Character(1) VARCHAR2(1) NOT NULL Form status.
C=Correction
D=Duplicate
O=Original
R=Reissue
V=Void

27 ACA_SS_UPD_ACTION Character(1) VARCHAR2(1) NOT NULL Update Flag: I - Insert D- Delete C- Change/Replace F - Failed update
C=Change
D=Delete
F=Failed
I=Insert

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
5	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	ACA_CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	1094-C/1095-C Calendar Year
8	ACA_ALE_MEM_GRP	Character(3)	VARCHAR2(3) NOT NULL	Applicable Large Employer
9	ACA_ALE_MEMBER	Character(3)	VARCHAR2(3) NOT NULL	Used to contain value of ALE Member name
10	ACA_FORM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	ACA Form Type. The default Value is 1095-C 1095=1095-C
11	ACA_SEQNO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
12	ACA_YE_FORM_SEQNUM	Number(2,0)	SMALLINT NOT NULL	A sequential number to indicate the number of Form 1095-C that have been issued/generated for an employee. Initial copy will have a value of 1.
13	ACA_PROCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Process type. C=Correction O=Original P=Replace Transmission Q=Replace Submission R=Reissue
14	ACA_FORM_ISSUE_DT	Date(10)	DATE	This field is used in ACA Self Service Forms. It stores the date when the forms were generated.
15	ACA_FORM_VIEW_DT	Date(10)	DATE	This field is used in ACA Self Service Year-End Forms. It stores the date that determines when the forms become viewable in Self Service.
16	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
17	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
18	ACA_YE_FILEURLID	Character(30)	VARCHAR2(30) NOT NULL	URL ID used to store and retrieve year-end pdf forms.
19	ACA_REPORT_URL	Character(254)	VARCHAR2(254) NOT NULL	Report URL.
20	ACA_BURST_ID	Character(40)	VARCHAR2(40) NOT NULL	Stores the value used for bursting a PDF file into separate employee-level files.
21	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
22	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN).
23	BURST_FIELDNAME	Character(30)	VARCHAR2(30) NOT NULL	Burst Field Name
24	ACA_NOTIFY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether notification of availability for viewing a year-end form has been sent to employee. Y - notification already sent to employee N - notification not yet sent to employee
25	ACA_FINAL_PRINT	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether final run or not. Y/N Table Edit
26	ACA_FORM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Form status. C=Correction D=Duplicate O=Original R=Reissue V=Void
27	ACA_SS_UPD_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Update Flag: I - Insert D- Delete C- Change/Replace F - Failed update C=Change D=Delete F=Failed I=Insert