SFA_ISIR_SIBLVW

(SQL View)
 Index Back

Sibling view for ISIR_CONT

2425: Additional record for ISIR Student data

SELECT ECTRANSID , ECQUEUEINSTANCE , ECTRANSINOUTSW , ISIR_SEQ_NO , CASE WHEN SFA_FTIM_STU_AGI= ' ' THEN 0 ELSE CAST(SFA_FTIM_STU_AGI AS DECIMAL) END , CASE WHEN SFA_FTIM_STU_NOE= ' ' THEN 0 ELSE CAST(SFA_FTIM_STU_NOE AS SMALLINT) END , CASE WHEN SFA_FTIM_STU_NOD= ' ' THEN 0 ELSE CAST(SFA_FTIM_STU_NOD AS SMALLINT) END , CASE WHEN SFA_FTIM_STU_TI= ' ' THEN 0 ELSE CAST(SFA_FTIM_STU_TI AS DECIMAL) END , CASE WHEN SFA_FTIM_STU_TAXP= ' ' THEN 0 ELSE CAST(SFA_FTIM_STU_TAXP AS DECIMAL) END , CASE WHEN SFA_FTIM_STU_EDUC= ' ' THEN 0 ELSE CAST(SFA_FTIM_STU_EDUC AS DECIMAL) END , CASE WHEN SFA_FTIM_STU_UNIRA= ' ' THEN 0 ELSE CAST(SFA_FTIM_STU_UNIRA AS DECIMAL) END , CASE WHEN SFA_FTIM_STU_DEIRA= ' ' THEN 0 ELSE CAST(SFA_FTIM_STU_DEIRA AS DECIMAL) END , CASE WHEN SFA_FTIM_STU_TAXEM= ' ' THEN 0 ELSE CAST(SFA_FTIM_STU_TAXEM AS DECIMAL) END , CASE WHEN SFA_FTIM_STU_UNTAX= ' ' THEN 0 ELSE CAST(SFA_FTIM_STU_UNTAX AS DECIMAL) END , CASE WHEN SFA_FTIM_STU_CSCHD= ' ' THEN 0 ELSE CAST(SFA_FTIM_STU_CSCHD AS DECIMAL) END , CASE WHEN SFA_FTIM_SPS_AGI= ' ' THEN 0 ELSE CAST(SFA_FTIM_SPS_AGI AS DECIMAL) END , CASE WHEN SFA_FTIM_SPS_NOE= ' ' THEN 0 ELSE CAST(SFA_FTIM_SPS_NOE AS SMALLINT) END , CASE WHEN SFA_FTIM_SPS_NOD= ' ' THEN 0 ELSE CAST(SFA_FTIM_SPS_NOD AS SMALLINT) END , CASE WHEN SFA_FTIM_SPS_TI= ' ' THEN 0 ELSE CAST(SFA_FTIM_SPS_TI AS DECIMAL) END , CASE WHEN SFA_FTIM_SPS_TAXP= ' ' THEN 0 ELSE CAST(SFA_FTIM_SPS_TAXP AS DECIMAL) END , CASE WHEN SFA_FTIM_SPS_EDUC= ' ' THEN 0 ELSE CAST(SFA_FTIM_SPS_EDUC AS DECIMAL) END , CASE WHEN SFA_FTIM_SPS_UNIRA= ' ' THEN 0 ELSE CAST(SFA_FTIM_SPS_UNIRA AS DECIMAL) END , CASE WHEN SFA_FTIM_SPS_DEIRA= ' ' THEN 0 ELSE CAST(SFA_FTIM_SPS_DEIRA AS DECIMAL) END , CASE WHEN SFA_FTIM_SPS_TAXEM= ' ' THEN 0 ELSE CAST(SFA_FTIM_SPS_TAXEM AS DECIMAL) END , CASE WHEN SFA_FTIM_SPS_UNTAX= ' ' THEN 0 ELSE CAST(SFA_FTIM_SPS_UNTAX AS DECIMAL) END , CASE WHEN SFA_FTIM_SPS_CSCHD= ' ' THEN 0 ELSE CAST(SFA_FTIM_SPS_CSCHD AS DECIMAL) END , CASE WHEN SFA_FTIM_PAR_AGI= ' ' THEN 0 ELSE CAST(SFA_FTIM_PAR_AGI AS DECIMAL) END , CASE WHEN SFA_FTIM_PAR_NOE= ' ' THEN 0 ELSE CAST(SFA_FTIM_PAR_NOE AS SMALLINT) END , CASE WHEN SFA_FTIM_PAR_NOD= ' ' THEN 0 ELSE CAST(SFA_FTIM_PAR_NOD AS SMALLINT) END , CASE WHEN SFA_FTIM_PAR_TI= ' ' THEN 0 ELSE CAST(SFA_FTIM_PAR_TI AS DECIMAL) END , CASE WHEN SFA_FTIM_PAR_TAXP= ' ' THEN 0 ELSE CAST(SFA_FTIM_PAR_TAXP AS DECIMAL) END , CASE WHEN SFA_FTIM_PAR_EDUC= ' ' THEN 0 ELSE CAST(SFA_FTIM_PAR_EDUC AS DECIMAL) END , CASE WHEN SFA_FTIM_PAR_UNIRA= ' ' THEN 0 ELSE CAST(SFA_FTIM_PAR_UNIRA AS DECIMAL) END , CASE WHEN SFA_FTIM_PAR_DEIRA= ' ' THEN 0 ELSE CAST(SFA_FTIM_PAR_DEIRA AS DECIMAL) END , CASE WHEN SFA_FTIM_PAR_TAXEM= ' ' THEN 0 ELSE CAST(SFA_FTIM_PAR_TAXEM AS DECIMAL) END , CASE WHEN SFA_FTIM_PAR_UNTAX= ' ' THEN 0 ELSE CAST(SFA_FTIM_PAR_UNTAX AS DECIMAL) END , CASE WHEN SFA_FTIM_PAR_CSCHD= ' ' THEN 0 ELSE CAST(SFA_FTIM_PAR_CSCHD AS DECIMAL) END , CASE WHEN SFA_FTIM_OTH_AGI= ' ' THEN 0 ELSE CAST(SFA_FTIM_OTH_AGI AS DECIMAL) END , CASE WHEN SFA_FTIM_OTH_NOE= ' ' THEN 0 ELSE CAST(SFA_FTIM_OTH_NOE AS SMALLINT) END , CASE WHEN SFA_FTIM_OTH_NOD= ' ' THEN 0 ELSE CAST(SFA_FTIM_OTH_NOD AS SMALLINT) END , CASE WHEN SFA_FTIM_OTH_TI= ' ' THEN 0 ELSE CAST(SFA_FTIM_OTH_TI AS DECIMAL) END , CASE WHEN SFA_FTIM_OTH_TAXP= ' ' THEN 0 ELSE CAST(SFA_FTIM_OTH_TAXP AS DECIMAL) END , CASE WHEN SFA_FTIM_OTH_EDUC= ' ' THEN 0 ELSE CAST(SFA_FTIM_OTH_EDUC AS DECIMAL) END , CASE WHEN SFA_FTIM_OTH_UNIRA= ' ' THEN 0 ELSE CAST(SFA_FTIM_OTH_UNIRA AS DECIMAL) END , CASE WHEN SFA_FTIM_OTH_DEIRA= ' ' THEN 0 ELSE CAST(SFA_FTIM_OTH_DEIRA AS DECIMAL) END , CASE WHEN SFA_FTIM_OTH_TAXEM= ' ' THEN 0 ELSE CAST(SFA_FTIM_OTH_TAXEM AS DECIMAL) END , CASE WHEN SFA_FTIM_OTH_UNTAX= ' ' THEN 0 ELSE CAST(SFA_FTIM_OTH_UNTAX AS DECIMAL) END , CASE WHEN SFA_FTIM_OTH_CSCHD= ' ' THEN 0 ELSE CAST(SFA_FTIM_OTH_CSCHD AS DECIMAL) END FROM PS_ISIR_00_2_EC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
2 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
4 ISIR_SEQ_NO Number(5,0) INTEGER NOT NULL Sequence Number
5 SFA_STD_FTIM_AGI Signed Number(11,0) DECIMAL(10) NOT NULL 2425:AGI
6 SFA_STD_FTIM_NOE Number(2,0) SMALLINT NOT NULL 2425:Number of exemptions
7 SFA_STD_FTIM_NOD Number(2,0) SMALLINT NOT NULL 2425:Number of dependents
8 SFA_STD_FTIM_TI Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Total income earned amount�
9 SFA_STD_FTIM_TAXP Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Total tax paid amount�
10 SFA_STD_FTIM_EDUC Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Educational credits
11 SFA_STD_FTIM_UNIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Untaxed IRA distributions
12 SFA_STD_FTIM_DEIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:IRA deductible and payments
13 SFA_STD_FTIM_TAXEM Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Tax exempt interest
14 SFA_STD_FTIM_UNTAX Signed Number(13,0) DECIMAL(12) NOT NULL Untaxed pensions amount
15 SFA_STD_FTIM_CSCHD Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C net profit/loss�
16 SFA_SPS_FTIM_AGI Signed Number(11,0) DECIMAL(10) NOT NULL 2425:AGI
17 SFA_SPS_FTIM_NOE Number(2,0) SMALLINT NOT NULL 2425:Number of exemptions
18 SFA_SPS_FTIM_NOD Number(2,0) SMALLINT NOT NULL 2425:Number of dependents
19 SFA_SPS_FTIM_TI Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Total income earned amount�
20 SFA_SPS_FTIM_TAXP Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Total tax paid amount�
21 SFA_SPS_FTIM_EDUC Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Educational credits
22 SFA_SPS_FTIM_UNIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Untaxed IRA distributions
23 SFA_SPS_FTIM_DEIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:IRA deductible and payments
24 SFA_SPS_FTIM_TAXEM Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Tax exempt interest
25 SFA_SPS_FTIM_UNTAX Signed Number(13,0) DECIMAL(12) NOT NULL Untaxed pensions amount
26 SFA_SPS_FTIM_CSCHD Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C net profit/loss�
27 SFA_PAR_FTIM_AGI Signed Number(11,0) DECIMAL(10) NOT NULL 2425:AGI
28 SFA_PAR_FTIM_NOE Number(2,0) SMALLINT NOT NULL 2425:Number of exemptions
29 SFA_PAR_FTIM_NOD Number(2,0) SMALLINT NOT NULL 2425:Number of dependents
30 SFA_PAR_FTIM_TI Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Total income earned amount�
31 SFA_PAR_FTIM_TAXP Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Total tax paid amount�
32 SFA_PAR_FTIM_EDUC Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Educational credits
33 SFA_PAR_FTIM_UNIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Untaxed IRA distributions
34 SFA_PAR_FTIM_DEIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:IRA deductible and payments
35 SFA_PAR_FTIM_TAXEM Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Tax exempt interest
36 SFA_PAR_FTIM_UNTAX Signed Number(13,0) DECIMAL(12) NOT NULL Untaxed pensions amount
37 SFA_PAR_FTIM_CSCHD Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C net profit/loss�
38 SFA_OTH_FTIM_AGI Signed Number(11,0) DECIMAL(10) NOT NULL 2425:AGI
39 SFA_OTH_FTIM_NOE Number(2,0) SMALLINT NOT NULL 2425:Number of exemptions
40 SFA_OTH_FTIM_NOD Number(2,0) SMALLINT NOT NULL 2425:Number of dependents
41 SFA_OTH_FTIM_TI Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Total income earned amount�
42 SFA_OTH_FTIM_TAXP Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Total tax paid amount�
43 SFA_OTH_FTIM_EDUC Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Educational credits
44 SFA_OTH_FTIM_UNIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Untaxed IRA distributions
45 SFA_OTH_FTIM_DEIRA Signed Number(13,0) DECIMAL(12) NOT NULL 2425:IRA deductible and payments
46 SFA_OTH_FTIM_TAXEM Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Tax exempt interest
47 SFA_OTH_FTIM_UNTAX Signed Number(13,0) DECIMAL(12) NOT NULL Untaxed pensions amount
48 SFA_OTH_FTIM_CSCHD Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C net profit/loss�