| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table:
SP_BU_SF_NONVW
|
| 5 |
IVC_PRT_RQST_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
Invoice Print Request Number
|
| 6 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 7 |
INVOICE_START |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Start Nbr
Prompt Table:
%EDITTABLE2
|
| 8 |
INVOICE_END |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Nbr End
Prompt Table:
%EDITTABLE3
|
| 9 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH_SF
|
| 10 |
BI_REQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Billing Request Nbr
Prompt Table:
%EDITTABLE
|
| 11 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 12 |
JF_FILE_DIR |
Character(45) |
VARCHAR2(45) NOT NULL |
Output File Directory
|
| 13 |
JF_BILL_FILE |
Character(8) |
VARCHAR2(8) NOT NULL |
Bill File
|
| 14 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Layout ID
Prompt Table:
BI_IVC_LAYOUT
|
| 15 |
ADDR_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table:
ADDR_USAGE_TBL
|
| 16 |
PRINT_BY_INVOICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Invoice by
A=Bill all Not yet Billed
B=Billing Request Number
C=Bill per Contract
D=Invoice Date
E=Customer ID
R=Invoice Range
X=Corp ID
Default Value: E
|
| 17 |
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
|
| 18 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 19 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 20 |
FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 21 |
JETFILE_CRYSTAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Jet or Crystal Format
C=Crystal Bill
J=Form Based Extract Bill
O=Other Bill (SQR)
X=XML Publisher
|
| 22 |
BILL_REQUEST_BY |
Character(4) |
VARCHAR2(4) NOT NULL |
Bill Request By
RQST=Bill Request Panel
RUNT=Run Control Panel
SING=SINGLE USE MODE
WKUP=Wake Up Mode
|
| 23 |
INVOICE_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Number
Prompt Table:
%EDITTABLE
|
| 24 |
DUE_DT |
Date(10) |
DATE |
Due Date
|
| 25 |
DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Due Days
|
| 26 |
BILL_REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Request ID
Prompt Table:
BI_STD_REQ_TBL
|
| 27 |
GENERATE_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate and Print Invoices
B=Generate & Print Bill
G=Generate Invoice
P=Print Bill
Default Value: P
|
| 28 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_SF_VW2
|
| 29 |
TYPE_OF_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Request
C=Organization
E=Student
|
| 30 |
PRT_CLASS_SCHEDULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Schedule of Classes
Y/N Table Edit
Default Value: N
|
| 31 |
OVERRIDE_ADDR_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Address Info
Y/N Table Edit
Default Value: N
|
| 32 |
OVERRIDE_ADDR_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Address not required
Y/N Table Edit
Default Value: N
|
| 33 |
OVRD_BIREQ_LAYOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Bill Request Layout
Y/N Table Edit
Default Value: N
|
| 34 |
PRT_TERM_SCHEDULE |
Character(4) |
VARCHAR2(4) NOT NULL |
Print Term Schedule
Prompt Table:
TERM_VAL_TBL
|
| 35 |
PRINT_ZERO_BILL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Zero Bill
Y/N Table Edit
Default Value: N
|
| 36 |
ANTIC_AID_TRM_FROM |
Character(4) |
VARCHAR2(4) NOT NULL |
Antic Aid Term From
Prompt Table:
TERM_VAL_TBL
|
| 37 |
ANTIC_AID_TERM_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Antic Aid Term To
Default Value: RUN_CNTL_PRTIVC.ANTIC_AID_TRM_FROM
Prompt Table:
TERM_VAL_TBL
|
| 38 |
USE_EMAIL_ADDR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Email Address
Y/N Table Edit
|
| 39 |
SSF_TEMP_ID_INV |
Character(30) |
VARCHAR2(30) NOT NULL |
XMLP Template Id
Prompt Table:
TL_TMPLT_RULE
|
| 40 |
SSF_TEMP_ID_CRINV |
Character(30) |
VARCHAR2(30) NOT NULL |
XMLP Template Id
Prompt Table:
TL_TMPLT_RULE
|
| 41 |
SSF_EURO_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Payments by Invoice
|
| 42 |
COMMON_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Common ID to store Personal ID / Ext Org ID value
|
| 43 |
SA_ID_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ID Type
O=Organization
P=Person
|
| 44 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 45 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 46 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 47 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
|
| 48 |
OPR_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Operators EmplID
|
| 49 |
SSF_PURGE_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Temp Table Purge Options
A=All Runs (Current and Prior)
C=Current Run Only
N=No Purge
P=Prior Runs Only
Default Value: N
|
| 50 |
SSF_NBR_PROC |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of Students Processed
|
| 51 |
SSF_NBR_SELECTED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of Invoices Selected
|
| 52 |
SSF_CHUNK_SIZE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Output Chunk Size
|
| 53 |
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
|
| 54 |
LS_CONTACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contact Type
Prompt Table:
ORG_CNT_TYP_TBL
|
| 55 |
SSF_OUTPUT_XML |
Character(1) |
VARCHAR2(1) NOT NULL |
Output XML Data
B=Yes
N=No
X=Output Only XML Data
|
| 56 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|