ACA_EE_XMT_H_VW

(SQL View)
 Index Back

ACA EE Transmit History View

A view of ACA employee 1095-C transmittal history.

SELECT A.ACA_DAT_EXTRACT_ID , A.ACA_ALE_MEMBER , A.ACA_CALENDAR_YEAR , A.ACA_PROCESS_TYPE , A.ACA_ALE_SEQNO , A.ACA_1094_SUBID , A.ACA_RECEIPT_ID , A.EMPLID , A.EFFSEQ , A.ACA_1095_RECID , A.ACA_REISSUE , A.ACA_VOID , A.ACA_XMIT_FILENAME , B.FIRST_NAME , B.MIDDLE_NAME , B.LAST_NAME FROM PS_ACA_EE_XMT_HIST A , PS_ACA_EMPLOYEE B WHERE A.ACA_DAT_EXTRACT_ID = B.ACA_DAT_EXTRACT_ID AND A.ACA_ALE_MEMBER = B.ACA_ALE_MEMBER AND A.ACA_CALENDAR_YEAR = B.ACA_CALENDAR_YEAR AND A.EMPLID = B.EMPLID AND A.EFFSEQ = B.EFFSEQ AND B.ACA_PRO_FLG = 'T'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACA_DAT_EXTRACT_ID Character(10) VARCHAR2(10) NOT NULL Extract ID for the ACA data
2 ACA_ALE_MEMBER Character(3) VARCHAR2(3) NOT NULL Used to contain value of ALE Member name
3 ACA_CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL 1094-C/1095-C Calendar Year
4 ACA_PROCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Process type.
C=Correction
O=Original
P=Replace Transmission
Q=Replace Submission
R=Reissue
5 ACA_ALE_SEQNO Number(3,0) SMALLINT NOT NULL ACA ALE Sequence
6 ACA_1094_SUBID Number(12,0) DECIMAL(12) NOT NULL Use to store 1094-C Submission ID number. Restriction:
7 ACA_RECEIPT_ID Character(30) VARCHAR2(30) NOT NULL ACA Receipt ID
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
10 ACA_1095_RECID Number(12,0) DECIMAL(12) NOT NULL Use to store 1095-C Record ID number. Restriction:
11 ACA_REISSUE Character(1) VARCHAR2(1) NOT NULL Form 1095C Reissue.
C=Correction
N=Original
Y=Reissue
12 ACA_VOID Character(1) VARCHAR2(1) NOT NULL Void Form 1095-C.
13 ACA_XMIT_FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
14 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
15 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
16 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name