| # |
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_PREC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Type
|
| 5 |
COMMON_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Common ID to store Personal ID / Ext Org ID value
|
| 6 |
SA_ID_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ID Type
O=Organization
P=Person
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 8 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
|
| 9 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
HCR_ADDR_TYP_I
|
| 10 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type ID
PP=Payment Plan
PRE=Pre-Payment
STU=Student
TP=Third Party
|
| 11 |
PRIOR_INVOICE_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Prior Invoice ID
|
| 12 |
INVOICE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Invoice
ADJ=Adjustment Only Bill
ARB=Rebill Bill
RAD=Regular bill with adjustments
REG=Regular Bill
Default Value: REG
|
| 13 |
BILL_REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Request ID
|
| 14 |
BI_REQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Billing Request Nbr
|
| 15 |
BILL_DATE_TIME |
DateTime(26) |
TIMESTAMP NOT NULL |
Bill Date and Time
Default Value: %date
|
| 16 |
DUE_DT |
Date(10) |
DATE NOT NULL |
Expected Birth Date
Default Value: %date
|
| 17 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID
Prompt Table:
OPR_DEF_TBL_CS
|
| 18 |
TOTAL_BILL |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Total Billed
|
| 19 |
SF_BILL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Status
C=Cancelled
I=Initiated
|
| 20 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 21 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
SCC_CNT_ADFMTVW
|
| 22 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 23 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 24 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 25 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 26 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 27 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 28 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 29 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 30 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 31 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 32 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 33 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 34 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 35 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 36 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 37 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 38 |
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
|
| 39 |
ACAD_CAREER_SRCH |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
|
| 40 |
ACAD_CAREER_INC |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
|
| 41 |
ACAD_PROG_PRIMARY |
Character(5) |
VARCHAR2(5) NOT NULL |
Primary Academic Program
|
| 42 |
ACAD_PROG_SRCH |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
|
| 43 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
|
| 44 |
ACAD_LEVEL_PROJ |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level - Projected
|
| 45 |
ACAD_LVL_PROJ_SRCH |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level - Projected
|
| 46 |
ACAD_LEVEL_PROJ_CL |
Character(3) |
VARCHAR2(3) NOT NULL |
Acad Level Proj Calculated
5AR=Fifth year Architecture
DOC=Doctorate
FR=Freshman
GR=Graduate
HS=High School Concurrent
JR=Junior
MAS=Masters
NDG=Non-deg Graduate
NDU=Non-deg Undergraduate
NST=Not Set
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PBC=Post-bacc Teach Certificate
PBU=Post-bacc Undergraduate
PMC=Post-mast Teach Cert
PPR=Post-Professional
PRE=Pre-Candidate
SO=Sophomore
SR=Senior
|
| 47 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
|
| 48 |
ACAD_PLAN_SRCH |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
|
| 49 |
ACAD_PLAN_INC |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
|
| 50 |
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
|
| 51 |
TUITION_RES |
Character(5) |
VARCHAR2(5) NOT NULL |
Tuition Residency
|
| 52 |
PRT_BILL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bill Flag
Y/N Table Edit
Default Value: N
|
| 53 |
RE_PRT_BILL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
RePrint Bill Flag
Y/N Table Edit
Default Value: N
|
| 54 |
PRT_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Print Date/Time Stamp
|
| 55 |
RE_PRT_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
RePrint Date/Time Stamp
|
| 56 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 57 |
PRIOR_IVC_BALANCE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Prior Invoice Amount
|
| 58 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 59 |
SSF_ERROR_WARN |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to hold translate values for Message Types - Error/Warning/Message
E=Error
M=Message
W=Warning
|
| 60 |
CONTACT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Contact Name
|
| 61 |
TYPE_OF_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Request
C=Organization
E=Student
|
| 62 |
BILL_BY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill By Indicator
C=Bill by Org/Contract
E=Bill by Student
O=By Organization
S=Bill by Org/Contr/Student
|
| 63 |
BI_SCAN_LINE |
Character(60) |
VARCHAR2(60) NOT NULL |
Bill Scan Line
|
| 64 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 65 |
CONTRACT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contract ID
|
| 66 |
CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
|
| 67 |
SSF_LATEFEE_POST |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used to identify whether Late Fee has been posted for BI_BILL_HEADER record.
Default Value: N
|
| 68 |
SSF_CR_INV_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Invoice
Y/N Table Edit
|
| 69 |
SSF_RELINV_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Related Invoice Amount
|
| 70 |
LS_CONTACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contact Type
Prompt Table:
ORG_CNT_TYP_TBL
|
| 71 |
BI_PRIOR_INV_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Prior Invoice Calc Option
1=Use Prior Invoice Amount
2=Account Balance Method
|
| 72 |
INVOICE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Invoices
A=Create Account Statements
C=Create Credit Invoices
I=Create Invoices
Default Value: I
|