SSF_INX_TMP(SQL Table) |
Index Back |
---|---|
Invoice Temp Record (Main)Temporary record used by the XMLPublisher AE program to print invoices. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | INVOICE_ID | Character(22) | VARCHAR2(22) NOT NULL | Invoice Number |
4 | SSF_PCOMM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Print Comm Destination
O=Original Communication X=Extra Communication |
5 | SSF_PCOMM_DESTID | Number(2,0) | SMALLINT NOT NULL | Print Comm Dest ID |
6 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
7 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
8 | INVOICE_DT | Date(10) | DATE | Invoice Date |
9 | BILL_REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Request ID |
10 | BI_REQ_NBR | Number(10,0) | DECIMAL(10) NOT NULL |
Billing Request Nbr
Prompt Table: BI_REQUEST |
11 | INVOICE_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL | Invoice Layout ID |
12 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
13 | TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL |
Template ID (see PSXPTMPLDEFN).
Prompt Table: PSXPRPTTMPL_VW |
14 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: SCC_CNT_ADFMTVW |
15 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
16 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
17 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
18 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
19 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
20 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
21 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
22 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
23 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
24 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
25 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
26 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
27 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
28 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
29 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
30 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
31 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
32 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
33 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
34 | INCLUDE_AA_TOTAL | Character(1) | VARCHAR2(1) NOT NULL |
Include Anticipated Aid Total
Y/N Table Edit Default Value: N |
35 | AA_DETAIL | Character(1) | VARCHAR2(1) NOT NULL |
Anticipated Aid Detail
Y/N Table Edit Default Value: N |
36 | TERM_SUMMARY | Character(1) | VARCHAR2(1) NOT NULL |
Term Summary
A=All Terms B=Current and Future Terms C=Current Term Only F=Future Only Default Value: A |
37 | TRANS_SORT_1 | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Sort Field 1
A=Due Date B=Item Number All C=Item Description E=Transaction Date G=Amount J=Account Number K=Term L=Session M=Academic Year P=Student ID (Third Party) Q=Student Name (Third Party) |
38 | TRANS_SORT_2 | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Sort Field 2
Prompt Table: BI_SORT_TRAN_VW |
39 | TRANS_SORT_3 | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Sort Field 3
Prompt Table: BI_SORT_TRAN_VW |
40 | TRANS_SORT_4 | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Sort Field 4
Prompt Table: BI_SORT_TRAN_VW |
41 | SUB_TOTAL_BY_1 | Character(1) | VARCHAR2(1) NOT NULL |
Subtotal By
Y/N Table Edit Default Value: N |
42 | SUMM_FIELD_1 | Character(1) | VARCHAR2(1) NOT NULL |
Summarization Field 1
A=Item Number All B=Item Description C=Item Type D=Account Number E=Item Nbr - Refund/Payment Only F=Item Type Code G=Student ID (Third Party) H=Student Name (Third Party) |
43 | SSF_SUMFLD1_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Summary Field 1 Descr |
44 | SUMM_FIELD_2 | Character(1) | VARCHAR2(1) NOT NULL |
Summarization Field 2
Prompt Table: BI_SUMM_FLD_VW |
45 | SSF_SUMFLD2_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Summary Field 2 Descr |
46 | BILL_SORT_1 | Character(1) | VARCHAR2(1) NOT NULL |
Bill Sort Field 1
A=Name B=Zip Code C=Total Amount Due D=Academic Program E=Academic Level F=Invoice Number G=Campus H=Tuition Residency I=Academic Load J=Student ID K=Country L=Corporation ID M=Student Enrollment Block N=Career Default Value: A |
47 | BILL_SORT_2 | Character(1) | VARCHAR2(1) NOT NULL |
Bill Sort Field 2
Prompt Table: BI_SORT_IVC_VW |
48 | BILL_SORT_3 | Character(1) | VARCHAR2(1) NOT NULL |
Bill Sort Field 3
Prompt Table: BI_SORT_IVC_VW |
49 | BILL_SORT_4 | Character(1) | VARCHAR2(1) NOT NULL |
Bill Sort Field 4
Prompt Table: BI_SORT_IVC_VW |
50 | SSF_EXTR_BNK_INFO | Character(1) | VARCHAR2(1) NOT NULL | Extract Bank Information |
51 | SSF_TPC_STDCHG_DEF | Character(1) | VARCHAR2(1) NOT NULL | Use Cross Ref Student Charge |
52 | SSF_TEMPLATE_CTRL | Character(4) | VARCHAR2(4) NOT NULL | Template Control Field |
53 | STDNT_ENRL_BLOCK | Character(5) | VARCHAR2(5) NOT NULL | Student Enrollment Block |
54 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
55 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
56 | TOTAL_BILL | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total Billed |
57 | ACAD_PROG_PRIMARY | Character(5) | VARCHAR2(5) NOT NULL | Primary Academic Program |
58 | ACAD_LEVEL_PROJ | Character(3) | VARCHAR2(3) NOT NULL | Academic Level - Projected |
59 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL | Campus |
60 | TUITION_RES | Character(5) | VARCHAR2(5) NOT NULL | Tuition Residency |
61 | ACADEMIC_LOAD | Character(1) | VARCHAR2(1) NOT NULL |
Academic Load
F=Enrolled Full-Time H=Enrolled Half-Time L=Less than Half-Time N=No Unit Load P=Enrolled Part-Time T=Three Quarter Time |
62 | SSF_ZIP_SRCH | Character(12) | VARCHAR2(12) NOT NULL | Postal Code |
63 | SSF_COUNTRY_SRCH | Character(3) | VARCHAR2(3) NOT NULL | Country |
64 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: ADM_FUNCTN_TBL |
65 | COMM_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL |
Communication Category
Prompt Table: COMM_CATG_VW2 |
66 | COMM_CONTEXT | Character(6) | VARCHAR2(6) NOT NULL |
Communication Context
Prompt Table: COMM_CA_CTX_VW |
67 | BILL_COMM_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Bill Comm. Flag
Y/N Table Edit Default Value: N |
68 | ALT_BILLING_CM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Additional Bill Communication
Y/N Table Edit Default Value: N |
69 | SCC_LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL |
Letter Code
Prompt Table: SCC_STN_LTR_TBL |
70 | LS_CONTACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Contact Type
Prompt Table: ORG_CNT_TYP_TBL |
71 | PRT_CLASS_SCHEDULE | Character(1) | VARCHAR2(1) NOT NULL | Print Schedule of Classes |
72 | PRT_TERM_SCHEDULE | Character(4) | VARCHAR2(4) NOT NULL | Print Term Schedule |
73 | OVERRIDE_ADDR_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Address not required
Y/N Table Edit Default Value: N |
74 | PRINT_ZERO_BILL | Character(1) | VARCHAR2(1) NOT NULL |
Print Zero Bill
Y/N Table Edit Default Value: N |
75 | LANG_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese |
76 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
77 | SSF_NAME_COMM | Character(50) | VARCHAR2(50) NOT NULL | Name of person receiving Comm |
78 | COUNTRY_OTHER | Character(3) | VARCHAR2(3) NOT NULL |
Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
Prompt Table: COUNTRY_TBL |
79 | ADDRESS1_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 1 Other |
80 | ADDRESS2_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 2 Other |
81 | ADDRESS3_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 3 Other |
82 | ADDRESS4_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 4 Other |
83 | CITY_OTHER | Character(30) | VARCHAR2(30) NOT NULL | City Other |
84 | COUNTY_OTHER | Character(30) | VARCHAR2(30) NOT NULL | County Other |
85 | STATE_OTHER | Character(6) | VARCHAR2(6) NOT NULL |
State Other
Prompt Table: STATE_OTH |
86 | POSTAL_OTHER | Character(12) | VARCHAR2(12) NOT NULL | Postal Other |
87 | NUM1_OTHER | Character(6) | VARCHAR2(6) NOT NULL | Number 1 Other |
88 | NUM2_OTHER | Character(6) | VARCHAR2(6) NOT NULL | Number 2 Other |
89 | HOUSE_TYPE_OTHER | Character(2) | VARCHAR2(2) NOT NULL |
House Type Other
AB=House Boat Reference WW=House Trailer Reference |
90 | ADDR_FIELD1_OTHER | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 Other |
91 | ADDR_FIELD2_OTHER | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 Other |
92 | ADDR_FIELD3_OTHER | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 Other |
93 | IN_CITY_LMT_OTHER | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit Other
Y/N Table Edit |
94 | GEO_CODE_OTHER | Character(11) | VARCHAR2(11) NOT NULL | Geo Code Other |
95 | PEOPLE_RELATION | Character(2) | VARCHAR2(2) NOT NULL |
Relationship
Default Value: NI |
96 | RELATIONSHIP_NBR | Number(2,0) | SMALLINT NOT NULL | Relationship Nbr |
97 | EMPLID_RELATED | Character(11) | VARCHAR2(11) NOT NULL | Related People ID |
98 | GUARDIAN_RELATIONS | Character(2) | VARCHAR2(2) NOT NULL |
Guardian Relationship
LG=Legal Guardian NA=Not Applicable OT=Other PG=Parent Guardian SG=Self Guardian XG=Primary Guardian Default Value: NA |
99 | ADDR_TYPE3 | Character(4) | VARCHAR2(4) NOT NULL | Address Type |
100 | SSF_INS_COMMLAST | Character(1) | VARCHAR2(1) NOT NULL | Insert Comm Last Rec |
101 | PRT_BILL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Print Bill Flag |