| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
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
|
| 4 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 5 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table:
SP_BU_SF_NONVW
|
| 7 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
Prompt Table:
TP_PAYP_CONT_VW
|
| 8 |
CASHIER_OFFICE |
Character(8) |
VARCHAR2(8) NOT NULL |
Cashier's Office
Prompt Table:
SP_CSHOFF_NONVW
|
| 9 |
RECEIPT_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Receipt Number
Prompt Table:
CSH_OFF_RECEIPT
|
| 10 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 11 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 12 |
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
|
| 13 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table:
ACAD_PROG_TBL
|
| 14 |
CONTACT |
Character(30) |
VARCHAR2(30) NOT NULL |
Contact Person
|
| 15 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
PEOPLE_SRCH
|
| 16 |
PLACED_PERSON_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
ID of person who placed the Service Indicator
Prompt Table:
PEOPLE_SRCH
|
| 17 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
TERM_VAL_TBL
|
| 18 |
AMOUNT |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Commuting Allowance Paid Per Cycle.
|
| 19 |
SEL_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Tuition Group
Prompt Table:
SEL_GROUP_TBL
|
| 20 |
CRITERIA |
Character(12) |
VARCHAR2(12) NOT NULL |
Criteria for Selector
Prompt Table:
FEE_TRIGGER_VW
|
| 21 |
LINE_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Line Sequence Nbr
Prompt Table:
GROUP_LINE
|
| 22 |
BEGIN_GRP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Begin Group ID
Prompt Table:
GROUP_CONT_INFO
|
| 23 |
END_GRP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group ID
Prompt Table:
GROUP_CONT_INFO
|
| 24 |
GROUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Type
Prompt Table:
GROUP_TYPE_TBL
|
| 25 |
GRP_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator ID
Prompt Table:
OPRID_VW
|
| 26 |
ASSN_GRP_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Assign Group OperID
Prompt Table:
OPRID_VW
|
| 27 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 28 |
ALL_TERM_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
All Terms
A=All Terms
V=Select a Value
Default Value: A
|
| 29 |
GRP_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Group Line Time Stamp
Prompt Table:
QUICK_POST_TBL
|
| 30 |
BATCH_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Batch ID
Default Value: 999999999999
Prompt Table:
CALC_ERR_MSG_VW
|
| 31 |
BATCH_ID_RFND |
Character(12) |
VARCHAR2(12) NOT NULL |
Refund Batch ID
Prompt Table:
REFUND_MSG_HDR
|
| 32 |
BATCH_ID_LAST_PP |
Character(12) |
VARCHAR2(12) NOT NULL |
Batch ID
Prompt Table:
REF_BATCH_ID_VW
|
| 33 |
BATCH_ID_CC |
Character(12) |
VARCHAR2(12) NOT NULL |
Batch ID used for processing refunds via the CyberSource Credit Card Interface
Prompt Table:
BATCH_ID_CC_VW
|
| 34 |
FROM_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
From Term
Prompt Table:
TERM_VAL_TBL
|
| 35 |
FROM_SESSION |
Character(3) |
VARCHAR2(3) NOT NULL |
From Session
Prompt Table:
SESSION_CODE_VW
|
| 36 |
TO_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
To Term
Prompt Table:
TERM_VAL_TBL
|
| 37 |
TO_SESSION |
Character(3) |
VARCHAR2(3) NOT NULL |
To Session
Prompt Table:
SESSION_CODE_VW
|
| 38 |
APP_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Fee
Y/N Table Edit
Default Value: N
|
| 39 |
CHARGE |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Original Charge
|
| 40 |
DEPOSIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit
Y/N Table Edit
Default Value: N
|
| 41 |
FIN_AID |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Aid
Y/N Table Edit
Default Value: N
|
| 42 |
PAYMENT |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Payment Amount
|
| 43 |
REFUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Refund
Y/N Table Edit
Default Value: N
|
| 44 |
WAIVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Waiver
Y/N Table Edit
Default Value: N
|
| 45 |
PAYMENT_ID_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Payment ID Nbr
|
| 46 |
ACCT_TYPE_ROLL |
Character(3) |
VARCHAR2(3) NOT NULL |
Account Type
Prompt Table:
ACCT_TYP_TBL_SF
|
| 47 |
TERM_FROM_ROLL |
Character(4) |
VARCHAR2(4) NOT NULL |
From Term
Prompt Table:
TERM_VAL_TBL
|
| 48 |
TERM_TO_ROLL |
Character(4) |
VARCHAR2(4) NOT NULL |
To Term
Prompt Table:
TERM_VAL_TBL
|
| 49 |
INCLUDE_ZERO |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Zero Balance Records
Y/N Table Edit
|
| 50 |
ACCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Status
A=Active
I=Inactive
Default Value: A
|
| 51 |
PAST_DUE_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Past Due Amount
|
| 52 |
PAST_DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days Past Due
|
| 53 |
ANTICIPATED_AID |
Character(1) |
VARCHAR2(1) NOT NULL |
Anticipated Aid
Y/N Table Edit
Default Value: N
|
| 54 |
ALL_PROGRAMS |
Character(1) |
VARCHAR2(1) NOT NULL |
All Programs
Y/N Table Edit
Default Value: N
|
| 55 |
ALL_CAREERS |
Character(1) |
VARCHAR2(1) NOT NULL |
All Careers
Y/N Table Edit
Default Value: N
|
| 56 |
ALL_ACCOUNTS |
Character(1) |
VARCHAR2(1) NOT NULL |
All Accounts
Y/N Table Edit
Default Value: N
|
| 57 |
ALL_TERMS |
Character(1) |
VARCHAR2(1) NOT NULL |
All Terms
Y/N Table Edit
Default Value: N
|
| 58 |
RPT_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Only
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 59 |
PAST_DUE_DATE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Past Due Date or Days
D=By Date
Y=By Days
Default Value: D
|
| 60 |
PAST_DUE_DATE |
Date(10) |
DATE |
Past Due Date
Default Value: %date
|
| 61 |
ACCOUNT_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Nbr
Prompt Table:
ACCOUNT_NBR_VW
|
| 62 |
ACCOUNT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Account Term
Prompt Table:
ACCOUNT_TERM_VW
|
| 63 |
AGING_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
Aging Set
Prompt Table:
AGING_TBL
|
| 64 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 65 |
BUDGET_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Budget Period
Prompt Table:
EG_BUDGET_PRD
Set Control Field: BUSINESS_UNIT
|
| 66 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 67 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 68 |
TO_DATE |
Date(10) |
DATE |
Latest Date to be sent to PYR
|
| 69 |
TO_DT |
Date(10) |
DATE |
To Date
Default Value: %date
|
| 70 |
REFUND_RUN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Refund Run Type
B=Both Financial Aid and Non FA
F=Financial Aid Only
N=Non Financial Aid Only
Default Value: B
|
| 71 |
ADDR_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table:
ADDR_USAGE_TBL
|
| 72 |
REFUND_ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Refund Item Type
Prompt Table:
ITEM_TYPE_RF_VW
|
| 73 |
SRVC_IND_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Indicator Set
Prompt Table:
SRVC_IND_SF_TBL
|
| 74 |
SRVC_IND_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Service Indicator Cd
Prompt Table:
SRVC_IND_CD_TBL
|
| 75 |
SRVC_IND_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Indicator Reason
Prompt Table:
SRVC_IN_RSN_TBL
|
| 76 |
SRVC_IND_REL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Release Service Indicator
|
| 77 |
SRVC_IND_SET_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Set Service Indicator
|
| 78 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
HCR_DEPT_I
|
| 79 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 80 |
CREDIT_HISTORY_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit History Update Flag
A=All IDs
D=Last Activity Date
O=One ID
R=ID Range
T=Temp Table
Default Value: A
|
| 81 |
SOURCE_IND_UPDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Indicator Update
Y/N Table Edit
Default Value: N
|
| 82 |
RUN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Run ID
Prompt Table:
SSF_PAY_RUN_VW
|
| 83 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
HCR_COMPANY_I
|
| 84 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
SSF_PAYGRP_VW
|
| 85 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
Prompt Table:
SSF_PAY_CALNDR
|
| 86 |
CYCLE_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Off-Cycle
B=Both
F=Off-Cycle
O=On-Cycle
Default Value: B
|
| 87 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Default Value: N
|
| 88 |
PAGE_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Page #
Prompt Table:
SSF_PAY_PAGE_VW
|
| 89 |
PAGE_NUM_THRU |
Number(4,0) |
SMALLINT NOT NULL |
Thru Page Number
Prompt Table:
SSF_PAY_PAGE_VW
|
| 90 |
PRENOTE_DT |
Date(10) |
DATE |
Prenote Date
|
| 91 |
TEXT15 |
Character(15) |
VARCHAR2(15) NOT NULL |
Text (15 Characters)
|
| 92 |
TEXT20 |
Character(20) |
VARCHAR2(20) NOT NULL |
Text (20 Characters)
|
| 93 |
CHECK_NO_START |
Number(7,0) |
INTEGER NOT NULL |
Starting Check Number
|
| 94 |
MESSAGE_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
|
| 95 |
ADVICE_NO_START |
Number(7,0) |
INTEGER NOT NULL |
Starting Advice Number
|
| 96 |
INVOICE_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Number
Prompt Table:
BILL_HEADER_VW2
|
| 97 |
GL_CHARGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Original Charge
Y/N Table Edit
Default Value: N
|
| 98 |
GL_PAYMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment
Y/N Table Edit
Default Value: N
|
| 99 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
Prompt Table:
JRNLGEN_APPL_ID
|
| 100 |
CURRENT_BUS_DT |
Date(10) |
DATE |
Current Business Date
Default Value: %date
Prompt Table:
CSH_RCPT_DT_VW
|
| 101 |
BUSINESS_DATE |
Date(10) |
DATE |
Business Date
Prompt Table:
CSH_BUS_DT_VW
|
| 102 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_TBL
|
| 103 |
EXT_ORG_SW1 |
Character(1) |
VARCHAR2(1) NOT NULL |
External Org Switch
Y/N Table Edit
Default Value: N
|
| 104 |
EMPLID_SW1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Emplid Switch
E=By Emplid
O=By Org ID
Default Value: E
|
| 105 |
LAST_ACTIVITY_DATE |
Date(10) |
DATE |
Last Activity Date
Default Value: %date
|
| 106 |
AGE_CATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
Aging Category
Prompt Table:
AGING_CAT_TBL
|
| 107 |
ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
Prompt Table:
ITEM_TYPE_TBL
|
| 108 |
ITEM_TYPE_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Item Type Group
Prompt Table:
ITEM_GROUP_TBL
|
| 109 |
ITEM_TYPE_WRITEOFF |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type Writeoff
Prompt Table:
SP_ITYPWF_NONVW
|
| 110 |
COPY_FEE_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Copy Term Fee Options
ALL=Copy All Term Fees
ONE=Copy One Term Fee
Default Value: ALL
|
| 111 |
FROM_FEE_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
From Fee Code
Prompt Table:
TERM_FE_CD_TBL
Set Control Field: SETID
|
| 112 |
TO_FEE_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
To Fee Code
|
| 113 |
AP_PATH_VENDOR |
Character(127) |
VARCHAR2(127) NOT NULL |
AP Vendor File Path and Name
|
| 114 |
AP_PATH_VOUCHER |
Character(127) |
VARCHAR2(127) NOT NULL |
AP Voucher File Path and Name
|
| 115 |
POSTED_DATE |
Date(10) |
DATE |
Date Posted
|
| 116 |
ADMIN_FUNCTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table:
ADM_FUNCTN_TBL
|
| 117 |
SCC_LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Letter Code
Prompt Table:
SCC_STN_LTR_TBL
|
| 118 |
LETTER_GEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Letter
|
| 119 |
COMM_CATEGORY |
Character(6) |
VARCHAR2(6) NOT NULL |
Communication Category
Prompt Table:
COMM_CATG_TBL
|
| 120 |
COMM_CONTEXT |
Character(6) |
VARCHAR2(6) NOT NULL |
Communication Context
Prompt Table:
COMM_CTXT_TBL
|
| 121 |
REASON_IN |
Character(3) |
VARCHAR2(3) NOT NULL |
Collection Reason In
Prompt Table:
REASON_IN_VW2
Set Control Field: BUSINESS_UNIT
|
| 122 |
REASON_OUT |
Character(3) |
VARCHAR2(3) NOT NULL |
Collection Reason Out
Prompt Table:
REASON_OUT_VW2
Set Control Field: BUSINESS_UNIT
|
| 123 |
BILLING_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Billing Career
Prompt Table:
ACAD_CAR_TBL
|
| 124 |
ALL_BUSINESS_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
All Business Unit's
Y/N Table Edit
Default Value: N
|
| 125 |
JOURNAL_PATH_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Journal File and Path name
|
| 126 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
General Ledger Unit
|
| 127 |
BILLING_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Only
Y/N Table Edit
Default Value: N
|
| 128 |
INTEREST |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest
Y/N Table Edit
Default Value: N
|
| 129 |
PAY_PLAN_CREDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Plan Credit
Y/N Table Edit
Default Value: N
|
| 130 |
WHITHHOLDING |
Character(1) |
VARCHAR2(1) NOT NULL |
Whithholding
Y/N Table Edit
Default Value: N
|
| 131 |
WRITEOFF |
Character(1) |
VARCHAR2(1) NOT NULL |
Writeoff
Y/N Table Edit
Default Value: N
|
| 132 |
USE_ACCOUNT_SF |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Exist on SF
Y/N Table Edit
Default Value: N
|
| 133 |
USE_CITIZEN_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Use All Citizenship
Y/N Table Edit
Default Value: N
|
| 134 |
USE_CITIZENSHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Citizenship Status
Y/N Table Edit
Default Value: N
|
| 135 |
USE_ENROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Student Eligible to Enroll
Y/N Table Edit
Default Value: N
|
| 136 |
USE_REFUND_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Setup Refund or Tax Records
R=Use Refund Data
T=Use Tax Data
Default Value: R
|
| 137 |
USE_RESIDENCY_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Residency All
Y/N Table Edit
Default Value: N
|
| 138 |
USE_VISA |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Visa Permit
Y/N Table Edit
Default Value: N
|
| 139 |
USE_VISA_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Visa Permit All
Y/N Table Edit
Default Value: N
|
| 140 |
USE_RESIDENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Residency in
Y/N Table Edit
Default Value: N
|
| 141 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 142 |
EFFECTIVE_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Effective Term
Prompt Table:
TERM_VAL_TBL
|
| 143 |
RESIDENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Residency
Prompt Table:
RESIDENCY_TBL
|
| 144 |
ORIGIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Origin ID
Prompt Table:
ORIGIN_TBL
|
| 145 |
CHARGE_PRIORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Charge Priority List
Prompt Table:
PMT_CHRG_TBL
|
| 146 |
LATE_FEE_RUN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Fees Run Options
1=Single Student
2=All Students
3=Single External Organization
4=All External Organizations
Default Value: 1
|
| 147 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
Default Value: %DATE
|
| 148 |
BACKDATE_DT |
Date(10) |
DATE |
Back Date
|
| 149 |
BACKDATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Back Date Flag
Y/N Table Edit
Default Value: N
|
| 150 |
AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Flag
A=Current Amount
C=Amount at Census Date
F=Amount at Fully Enrolled Date
Default Value: A
|
| 151 |
UPDATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Flag
A=All Enrollments
N=New Enrollments Only
Default Value: A
|
| 152 |
REFUND_ALL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate if all item types within selected group are to be refunded.
N=No
Y=Yes
|
| 153 |
CALENDAR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Calendar Year
|
| 154 |
COMB_PERIOD |
Character(8) |
VARCHAR2(8) NOT NULL |
Combination Period
Prompt Table:
CNST_CMB_PR_TBL
|
| 155 |
JF_FILE_DIR |
Character(45) |
VARCHAR2(45) NOT NULL |
Output File Directory
|
| 156 |
JF_FILENAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Extract File
|
| 157 |
SERVICE_IMPACT |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Impact
Prompt Table:
SRVC_IMPACT_TBL
|
| 158 |
ALL_PROG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
All Programs
Y/N Table Edit
|
| 159 |
EDIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Editing
E=Edited
N=Not Edited
|
| 160 |
POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Status
B=Balance
C=Complete
E=Errors
I=Incomplete
N=Not Posted
R=Reversed
|
| 161 |
EMPLID_ORG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Emplid / Ext Org Switch
B=Individual and Organization
I=Individual Only
O=Organization Only
Default Value: B
|
| 162 |
GROUP_ID_SF |
Character(15) |
VARCHAR2(15) NOT NULL |
Group ID
Prompt Table:
GROUP_CONT_INFO
|
| 163 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 164 |
TRACER_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Tracer Number
|
| 165 |
ITEM_EFFECTIVE_DT |
Date(10) |
DATE |
Item Effective Date
|
| 166 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID
Prompt Table:
CRED_HIST_TMPVW
|
| 167 |
START_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Start EmplID
Prompt Table:
PEOPLE_SRCH
|
| 168 |
START_EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Start Ext Org ID
Prompt Table:
EXT_ORG_TBL
|
| 169 |
END_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
End EmplID
Prompt Table:
PEOPLE_SRCH
|
| 170 |
END_EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
End Ext Org ID
Prompt Table:
EXT_ORG_TBL
|
| 171 |
SF_DEPOSIT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Deposit ID
|
| 172 |
TP_CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Thrid Party Contract Number
Prompt Table:
TP_CONTRCT_SRCH
|
| 173 |
ID_OPTION_SF |
Character(1) |
VARCHAR2(1) NOT NULL |
ID Option
C=By External Organization
S=By Student
Default Value: S
|
| 174 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
Prompt Table:
SF_ACCT_ERR_SRC
|
| 175 |
CALC_TUIT_IF_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc Tuition if Required
Y/N Table Edit
Default Value: N
|
| 176 |
DETAIL_REPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Detail
N=No Detail Report
Y=Detail Report
Default Value: Y
|
| 177 |
DUE_DATE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Due Date Option
L=Null
N=New Due Date
O=Old Due Date
Default Value: O
|
| 178 |
DUE_DT |
Date(10) |
DATE |
Due Date
|
| 179 |
APPLIED_AMT_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Applied Amt Rpt Flag
Y/N Table Edit
Default Value: N
|
| 180 |
BALANCE_AMT_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Balance Amt Rpt Flag
Y/N Table Edit
Default Value: N
|
| 181 |
EMPLID_ACT_BAL_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
EmplId Acct Bal Rpt
Y/N Table Edit
Default Value: N
|
| 182 |
INITIAL_RUN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Initial Run Flag
Y/N Table Edit
Default Value: N
|
| 183 |
ITEM_AMT_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Amt Rpt Flag
Y/N Table Edit
Default Value: N
|
| 184 |
ITEM_DUE_DT_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Due Dt Rpt Flag
Y/N Table Edit
Default Value: N
|
| 185 |
ORG_ACCT_BAL_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Org Acct Bal Rpt Flag
Y/N Table Edit
Default Value: N
|
| 186 |
PAYMENT_AMT_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Amt Rpt Flag
Y/N Table Edit
Default Value: N
|
| 187 |
REFUND_AMT_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Refund Amt Rpt Flag
Y/N Table Edit
Default Value: N
|
| 188 |
XREF_CON_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Reference Contract Nbr
Y/N Table Edit
Default Value: N
|
| 189 |
XREF_EFFDT_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Reference Effective Date
Y/N Table Edit
Default Value: N
|
| 190 |
XREF_ITEM_AMT_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Reference Item Amount
Y/N Table Edit
|
| 191 |
XREF_PID_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Reference Payment ID
Y/N Table Edit
Default Value: N
|
| 192 |
XREF_COMMID_TBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Reference CommonID Table
Y/N Table Edit
|
| 193 |
XREF_COMMID_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Reference CommonID Field
Y/N Table Edit
|
| 194 |
UPDATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Flag
Y/N Table Edit
Default Value: N
|
| 195 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 196 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 197 |
FROM_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
From ID
Prompt Table:
%EDITTABLE2
|
| 198 |
TO_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
To ID
Prompt Table:
%EDITTABLE2
|
| 199 |
SPONSOR_REFUND_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sponsor Refund Option
B=Individual and Organization
I=Individual Sponsors
N=No Sponsor
O=Organization Sponsors
Default Value: N
|
| 200 |
GROUP_LEVEL_COMMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Level Commit
E=Commit At the End
L=Commit Level
V=Commit Every Transaction
Default Value: E
|
| 201 |
GROUP_POST_COMMIT |
Number(6,0) |
INTEGER NOT NULL |
Group Posting Commit
|
| 202 |
PRINT_CARD_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Credit Card Info
Default Value: N
|
| 203 |
PRINT_CARD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Credit Card Type
Default Value: N
|
| 204 |
PRINT_CARD_NBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Credit Card Nbr
Default Value: N
|
| 205 |
PRINT_CARD_EXPDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Credit Card Exp Date
|
| 206 |
ALIGN_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Alignment Count
|
| 207 |
ALIGN_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Alignment Only
|
| 208 |
GL_PATH_SFACTLND |
Character(127) |
VARCHAR2(127) NOT NULL |
Output File Path and Name
|
| 209 |
REFUND_RUN_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Refund Run Format
A=All Formats
C=Credit Card
E=Electronic Check
|
| 210 |
COLLECTOR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Collector Type
O=Collector Assigned by User ID
R=Collector Assigned By Role
|
| 211 |
ORG_CONTACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contact Type
Prompt Table:
ORG_CNT_TYP_TBL
|
| 212 |
SERVICE_IMPACT_SF |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Impact SF
Prompt Table:
SSF_SVCIMP_D_VW
|
| 213 |
SSF_ACTDATE_OPTNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Activity Date Options
D=Use This Date
L=Use Last Run Date
R=Use Run Date Minus (days)
Default Value: D
|
| 214 |
SSF_TEMP_LACTY_DT |
Date(10) |
DATE |
Last Activity Date
Default Value: %date
|
| 215 |
SSF_ACTDATE_REL |
Number(3,0) |
SMALLINT NOT NULL |
Last Activity Date Options
Default Value: 1
|
| 216 |
SSF_TEMP_PROC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Only
A=Last Activity and Age History
L=Last Activity
R=To Release Service Indicators
Default Value: L
|
| 217 |
SSF_PROC_MAX_AGED |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Max Aged History
Y/N Table Edit
Default Value: N
|
| 218 |
SCCPS_POP_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.
Y/N Table Edit
Default Value: Y
|
| 219 |
SCCPS_TOOL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Tool ID - the unique key for a pop select tool
Prompt Table:
SCCPS_TOOL_VW
|
| 220 |
SCCPS_QUERY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Query / Section name used by population selection
Prompt Table:
%EDITTABLE
|
| 221 |
SCCPS_CNTXT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Context ID - the unique key that identifies the pop selection context
Prompt Table:
SCCPS_CNTXT_VW
|
| 222 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 223 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 224 |
SCCPS_FILE_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Pop Select File Path and Name
|
| 225 |
SSF_RFND_EVT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Default 3Cs Event ID for Refunding
Prompt Table:
SSF_RF_EVT3C_VW
|
| 226 |
REFUND_METHODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Refund Method
A=Accounts Payable
O=Other
P=Payroll
|