| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table:
SP_BU_SF_NONVW
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: BUS_UNIT_TBL_SF.DESCR
|
| 4 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
CAMPUS_LOC_TBL
|
| 5 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
General Ledger Unit
Prompt Table:
BUS_UNIT_TBL_GL
|
| 6 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
BUS_UNIT_SF_AP
|
| 7 |
ORIGIN_AP |
Character(3) |
VARCHAR2(3) NOT NULL |
AP Origin ID
Prompt Table:
ORIGIN_TBL
|
| 8 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 9 |
REFUND_DEBIT_BAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Refund Debit Balances
Y/N Table Edit
Default Value: N
|
| 10 |
AUTO_REFUND_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Days Between Refunds
|
| 11 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 12 |
CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
Prompt Table:
CAMPUS_TBL
|
| 13 |
LAST_GROUP_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Last Group ID
|
| 14 |
ACCOUNTING_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Method
A=Accrual Accounting
C=Cash Accounting
M=Modified Cash Accounting
|
| 15 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 16 |
LAST_BI_MSG_NBR |
Number(5,0) |
INTEGER NOT NULL |
Last Billing Msg Nbr
|
| 17 |
TREE_NAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Charge Priority Tree Name
Prompt Table:
PSTREEDEFN
|
| 18 |
TREE_NAME2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Item Tree Name
Prompt Table:
PSTREEDEFN
|
| 19 |
TREE_NAME3 |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name 3
Prompt Table:
PSTREEDEFN
|
| 20 |
GROUP_ID_SF |
Character(15) |
VARCHAR2(15) NOT NULL |
Group ID
|
| 21 |
LINK_TO_COMM |
Character(1) |
VARCHAR2(1) NOT NULL |
Link to Communications?
Y/N Table Edit
Default Value: N
|
| 22 |
COMM_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Communication Method
B=Publication
D=Document
E=E-Mail
F=Fax
L=Letter
P=Personal Contact
T=Telephone Call
W=Web
|
| 23 |
AGING_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
Aging Set
|
| 24 |
ADDR_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Usage
|
| 25 |
IVC_PRT_RQST_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
Invoice Print Request Number
|
| 26 |
MIN_REFUND |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Minimum Refund
|
| 27 |
MAX_REFUND |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Maximum Refund
|
| 28 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 29 |
REFUND_METHODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Refund Method
A=Accounts Payable
O=Other
P=Payroll
Default Value: P
|
| 30 |
COLL_ADM_FUNCTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Administrative Function
|
| 31 |
COLL_CMNT_CATEGORY |
Character(6) |
VARCHAR2(6) NOT NULL |
Comment Category
|
| 32 |
LAST_ORIGIN_ID |
Number(5,0) |
INTEGER NOT NULL |
Last Origin ID
|
| 33 |
BI_REQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Billing Request Nbr
|
| 34 |
FINAID_REFUND_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Batch Financial Aid Only
|
| 35 |
BOTH_REFUND_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Batch Both FA and Non FA
|
| 36 |
NONFA_REFUND_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Batch Non Financial Aid Only
|
| 37 |
ROLEUSER |
Character(30) |
VARCHAR2(30) NOT NULL |
Role User
|
| 38 |
SRVC_IND_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Indicator Set
|
| 39 |
SRVC_CSH_CHK |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Cash Check
|
| 40 |
SRVC_REFUND |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Refund
|
| 41 |
SRVC_TAKE_CHK |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Take Check
|
| 42 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 43 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
HCR_JOBCODE_I
|
| 44 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSN_DATA_VW
|
| 45 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
|
| 46 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 47 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 48 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
|
| 49 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
HCR_DEPT_I
|
| 50 |
FWT_ADDL_PCT |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
FWT Additional Percentage
|
| 51 |
FWT_ALLOWANCES |
Number(3,0) |
SMALLINT NOT NULL |
FWT Allowances
|
| 52 |
SWT_ADDL_PCT |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
SWT Additional Percentage
|
| 53 |
USE_RESIDENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Residency in
Y/N Table Edit
Default Value: Y
|
| 54 |
ACCOUNT_TYPE_SF |
Character(3) |
VARCHAR2(3) NOT NULL |
Account Type
Prompt Table:
ACCT_TYP_TBL_SF
|
| 55 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor Set ID
|
| 56 |
NEXT_VENDOR_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Vendor ID
Default Value: 1
|
| 57 |
PAST_DUE_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Past Due Amount
|
| 58 |
PAST_DUE_AMT_ORG |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Past Due Amount Org
|
| 59 |
PAST_DUE_CAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Past Due Category
|
| 60 |
PAST_DUE_CAT_ORG |
Character(2) |
VARCHAR2(2) NOT NULL |
Past Due Category Org
|
| 61 |
REASSIGN_COLLECTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Reassign Collector
Y/N Table Edit
Default Value: N
|
| 62 |
NEXT_COLLECT_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Next Collect ID
|
| 63 |
ASSIGN_NEW_COLL_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign New Collection ID
Y/N Table Edit
Default Value: N
|
| 64 |
ADMIN_FUNCTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Administrative Function
|
| 65 |
COMM_CATEGORY |
Character(6) |
VARCHAR2(6) NOT NULL |
Communication Category
Prompt Table:
COMM_CATG_TBL
|
| 66 |
COMM_CONTEXT |
Character(6) |
VARCHAR2(6) NOT NULL |
Communication Context
Prompt Table:
COMM_CTXT_TBL
|
| 67 |
CHECKLIST_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Checklist Code
Prompt Table:
CHECKLIST_TBL
|
| 68 |
CHKLST_ITEM_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Checklist Item Code
|
| 69 |
SRVC_IND_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Service Indicator Cd
|
| 70 |
LAST_AGING_DTTM |
DateTime(26) |
TIMESTAMP |
Last Aging
|
| 71 |
LAST_AGING_DTTM_OR |
DateTime(26) |
TIMESTAMP |
Last Aging ORG
|
| 72 |
EXIT_DUE_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Exit Due Amount
|
| 73 |
EXIT_DUE_AMT_ORG |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Exit Due Amount Org
|
| 74 |
EXIT_DUE_CAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Exit Due Category
|
| 75 |
EXIT_DUE_CAT_ORG |
Character(2) |
VARCHAR2(2) NOT NULL |
Exit Due Category Org
|
| 76 |
COLLECTOR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Collector Type
O=Collector Assigned by User ID
R=Collector Assigned By Role
|
| 77 |
REF_APPR_1_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Approval 1 Amt
|
| 78 |
REF_APPR_2_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Approval 2 Amt
|
| 79 |
REF_APPR_3_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Approval 3 Amt
|
| 80 |
REF_ORG_APPR1_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Approval 1 Amt
|
| 81 |
REF_ORG_APPR2_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Approval 2 Amt
|
| 82 |
REF_ORG_APPR3_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Approval 3 Amt
|
| 83 |
REF_APPR_1_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval for Amount 1
Y/N Table Edit
Default Value: N
|
| 84 |
REF_APPR_2_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval for Amount 2
Y/N Table Edit
Default Value: N
|
| 85 |
REF_APPR_3_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval for Amount 3
Y/N Table Edit
Default Value: N
|
| 86 |
REF_ORG_APPR1_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval for Amount 1
Y/N Table Edit
Default Value: N
|
| 87 |
REF_ORG_APPR2_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval for Amount 2
Y/N Table Edit
Default Value: N
|
| 88 |
REF_ORG_APPR3_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval for Amount 3
Y/N Table Edit
Default Value: N
|
| 89 |
REF_APPR_ACTIVE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Activate On-line Approvals
Y/N Table Edit
Default Value: N
|
| 90 |
REF_ORG_APPACTV_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Activate On-line Approvals
Y/N Table Edit
Default Value: N
|
| 91 |
REF_APPR_BATCH_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Activate Batch Approvals
Y/N Table Edit
Default Value: N
|
| 92 |
REFUND_SRVC_IND_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Refund Service Ind Code
|
| 93 |
REFUND_SRVC_IN_RSN |
Character(5) |
VARCHAR2(5) NOT NULL |
Refund Service Ind Reason
|
| 94 |
REFUND_APP_ROLE1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 1 Role Name
Prompt Table:
PSROLEDEFN
|
| 95 |
REFUND_APP_ROLE2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 2 Role Name
Prompt Table:
PSROLEDEFN
|
| 96 |
REFUND_APP_ROLE3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 3 Role Name
Prompt Table:
PSROLEDEFN
|
| 97 |
REF_ORG_APP_ROLE1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 1 Role Name
Prompt Table:
PSROLEDEFN
|
| 98 |
REF_ORG_APP_ROLE2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 2 Role Name
Prompt Table:
PSROLEDEFN
|
| 99 |
REF_ORG_APP_ROLE3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 3 Role Name
Prompt Table:
PSROLEDEFN
|
| 100 |
CHNG_REFUND_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Changes in Refund Method
Y/N Table Edit
|
| 101 |
GROUP_POST_COMMIT |
Number(6,0) |
INTEGER NOT NULL |
Group Posting Commit
|
| 102 |
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: V
|
| 103 |
GROUP_APPR_ROLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Group Approval Role
Prompt Table:
PSROLEDEFN
|
| 104 |
GROUP_APPR_ROLE_UB |
Character(30) |
VARCHAR2(30) NOT NULL |
UnBal Group Approval Role
Prompt Table:
PSROLEDEFN
|
| 105 |
DEF_FA_ACCT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Default Financial Aid Account
Prompt Table:
ACCT_TYP_TBL_SF
|
| 106 |
NRA_TAXATION_SWTCH |
Character(1) |
VARCHAR2(1) NOT NULL |
NRA Taxation Option
C=NRA Tax W/Current Info
N=No NRA Taxes
Default Value: N
|
| 107 |
STATE_NRA |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 108 |
SAL_ADMIN_PLAN_NRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Administration Plan
|
| 109 |
POSITION_NBR_NRA |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 110 |
PAYGROUP_NRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 111 |
LOCALITY_NRA |
Character(7) |
VARCHAR2(7) NOT NULL |
Locality
|
| 112 |
JOBCODE_NRA |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 113 |
DEPTID_NRA |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 114 |
COMPANY_NRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 115 |
BENEFIT_PROGRM_NRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Benefit Program
|
| 116 |
ITEM_TYPE_FED_1042 |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
|
| 117 |
ITEM_TYPE_LOC_1042 |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
|
| 118 |
ITEM_TYPE_STA_1042 |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
|
| 119 |
AP_ADDRESS_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
AP Address Sequence Number
|
| 120 |
STATE_TAX_RT |
Number(7,6) |
DECIMAL(6,6) NOT NULL |
State Tax Rate
|
| 121 |
LOCAL_TAX_RT |
Number(7,6) |
DECIMAL(6,6) NOT NULL |
Local Tax Rate
|
| 122 |
ACCT_TYPE_NRA_TAX |
Character(3) |
VARCHAR2(3) NOT NULL |
Federal Withholding Account
Prompt Table:
ACCT_TYP_TBL_SF
|
| 123 |
FEDERAL_TAX_RT |
Signed Number(8,6) |
DECIMAL(6,6) NOT NULL |
Federal Tax Rate
|
| 124 |
DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr
|
| 125 |
DESCR2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr2
|
| 126 |
DESCR3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr 3
|
| 127 |
NRA_OPTION_EARNING |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Options For Earnings
A=Payroll Adjustments-All
B=Payroll via Paysheet
N=No Calculation
P=Payroll Adj.-Positive Only
X=Calculate - No Interface
Default Value: N
|
| 128 |
NRA_OPTION_WITHHOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Options For Withholdin
C=Calculate-No Interface
N=Do Not Calculate
S=Send SF To Payroll
U=Update SF From Payroll
Default Value: N
|
| 129 |
CANC_ACTION_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Term / Classes Cancel Reason
|
| 130 |
FED_TAX_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Tax Calculation
N=NRA Only
X=No Federal Calculation
Default Value: N
|
| 131 |
STATE_TAX_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
State Tax Calculation
A=All Students
N=NRA Only
O=Non-Residents Only
R=Residents Only
X=No State Tax Calculation
Default Value: N
|
| 132 |
LOCAL_TAX_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Local Tax Calculation
A=All Students
N=NRA Only
O=Non-Residents Only
R=Residents Only
X=No Local Tax Calculation
Default Value: N
|
| 133 |
CREATE_FED_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Fed Tax Records
Y/N Table Edit
Default Value: N
|
| 134 |
CREATE_JOB_RECS |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Job Records
N=No
O=Only if No Job Exists
Y=Yes
Default Value: N
|
| 135 |
CREATE_LOCAL_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Local Tax Records
Y/N Table Edit
Default Value: N
|
| 136 |
CREATE_STATE_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Create State Tax Records
Y/N Table Edit
Default Value: N
|
| 137 |
DEFAULT_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Default State for NRA Calc
|
| 138 |
TP_CON_AUTO_NUM_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Auto Number for Contracts
Y/N Table Edit
Default Value: N
|
| 139 |
TP_CON_NXT_CON_NBR |
Character(25) |
VARCHAR2(25) NOT NULL |
Next Contract Number
|
| 140 |
LINE_REASON_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Line Reason Code
|
| 141 |
AP_VOUCHER_SEQ_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Sequencing By
A=Automatic Sequencing
R=Use SF Refund# as Voucher#
Default Value: A
|
| 142 |
AP_PREFIX_SF |
Character(2) |
VARCHAR2(2) NOT NULL |
Ap Prefix
|
| 143 |
VCHR_NUM_LAST_USED |
Number(8,0) |
INTEGER NOT NULL |
Last Voucher Number
|
| 144 |
SPECIAL_FWT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Special FWT Status
A=Nonresident alien
E=No taxable gross; no tax taken
G=Maintain taxable gross
N=None
|
| 145 |
FWT_MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FWT Marital Status
H=Head of Household
M=Married
S=Single
X=Exempt
|
| 146 |
FWT_ALLOWANCE_TAX |
Number(3,0) |
SMALLINT NOT NULL |
FWT Allowances
|
| 147 |
FWT_ADDL_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
FWT Additional Amount
|
| 148 |
FWT_ADDL_PCT_TAX |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
FWT Additional Percentage
|
| 149 |
SPECIAL_SWT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Tax Status
A=Nonresident alien (Fed Rules)
E=No taxable gross; no tax taken
G=Maintain taxable gross
N=None
|
| 150 |
SWT_MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
SWT Marital/Tax Status
|
| 151 |
SWT_ALLOWANCES |
Number(3,0) |
SMALLINT NOT NULL |
Withholding Allowances
|
| 152 |
SWT_ADDL_ALLOWNCES |
Number(3,0) |
SMALLINT NOT NULL |
Additional Allowances
|
| 153 |
SWT_ADDL_AMT |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
SWT Additional Amount
|
| 154 |
SWT_ADDL_PCT_TAX |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
SWT Additional Percentage
|
| 155 |
LWT_ALLOWANCES |
Number(3,0) |
SMALLINT NOT NULL |
Local Withholding Allowances
|
| 156 |
LWT_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Additional Amount
|
| 157 |
LWT_PCT |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
Additional Percentage
|
| 158 |
FWT_ADDL_AMT_TAX |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
FWT Additional Amount
|
| 159 |
FWT_MAR_STATUS_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
FWT Marital Status
M=Married
S=Single
|
| 160 |
LWT_ALLOWANCES_TAX |
Number(2,0) |
SMALLINT NOT NULL |
Local Withholding Allowances
|
| 161 |
LWT_AMT_TAX |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Flat Amount
|
| 162 |
LWT_PCT_TAX |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
Flat Percentage
|
| 163 |
LWT_MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
LWT Marital/Tax Status
|
| 164 |
SPECL_SWT_STAT_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Tax Status
A=N/R Alien
E=Exempt
G=Maintain gross
N=None
|
| 165 |
SWT_ADDL_ALLOW_TAX |
Number(3,0) |
SMALLINT NOT NULL |
Additional Allowances
|
| 166 |
SWT_ADDL_AMT_TAX |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
SWT Additional Amount
|
| 167 |
SWT_ALLOWANCES_TAX |
Number(3,0) |
SMALLINT NOT NULL |
Withholding Allowances
|
| 168 |
SWT_MAR_STATUS_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
SWT Marital/Tax Status
|
| 169 |
ACCT_TYPE_LOCAL |
Character(3) |
VARCHAR2(3) NOT NULL |
Local Withholding Account
Prompt Table:
ACCT_TYP_TBL_SF
|
| 170 |
ACCT_TYPE_STATE |
Character(3) |
VARCHAR2(3) NOT NULL |
State Withholding Account
Prompt Table:
ACCT_TYP_TBL_SF
|
| 171 |
SPECIAL_FWT_ST_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Special FWT Status
A=Non-Resident Alien
E=Exempt (not subject to FIT)
G=Maintain gross (no tax WH)
N=None
|
| 172 |
GL_LEVEL_COMMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Commit Level
E=Commit at the End
L=Commit Level
V=Commit Every Item
Default Value: V
|
| 173 |
GL_POST_COMMIT |
Number(6,0) |
INTEGER NOT NULL |
GL Post Commit
|
| 174 |
GL_MAX_ERROR_ALLOW |
Number(6,0) |
INTEGER NOT NULL |
GL Max Error Before Stopping
|
| 175 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 176 |
T4_COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
T4 Company
Prompt Table:
HCR_COMPANY_I
|
| 177 |
T4_PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 178 |
T4_BALANCE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
T4 Balance ID
Prompt Table:
BALANCE_ID_TBL
|
| 179 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
Prompt Table:
PROVINCE_NM_VW
|
| 180 |
T4_DATE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Type
1=Posting date
2=Item Effective Date
3=Run Date
Default Value: 3
|
| 181 |
WAGE_LOSS_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
|
| 182 |
ORIGIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Origin ID
|
| 183 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_TBL
|
| 184 |
GROUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Type
CLGP=Clockgroup
TKGP=Taskgroup
WKGP=Workgroup
|
| 185 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Default Value: INSTALLATION.COUNTRY
|
| 186 |
USE_ETHNIC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Ethnicity
Y/N Table Edit
Default Value: N
|
| 187 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
Prompt Table:
SP_SETID_NONVW
|
| 188 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
Prompt Table:
SP_SETID_NONVW
|
| 189 |
BUSINESS_UNIT_HR |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit for HCM
Prompt Table:
HCR_BS_UNT_HR_I
|
| 190 |
BATCH_ID_LAST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Last Batch ID
|
| 191 |
NEXT_BI_PRT_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
Next Billing Print Request
|
| 192 |
CAMPUS_ID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Campus ID Online
Y/N Table Edit
Default Value: N
|
| 193 |
NATIONAL_ID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display National ID Online
Y/N Table Edit
Default Value: N
|
| 194 |
REF_DB |
Character(1) |
VARCHAR2(1) NOT NULL |
Ref Debit Item Flag
Y/N Table Edit
Default Value: N
|
| 195 |
REF_EXCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Ref Excess Payment Flag
Y/N Table Edit
Default Value: Y
|
| 196 |
REF_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Ref Item Payment Flag
Y/N Table Edit
Default Value: N
|
| 197 |
TERM_ACT_INIT_SET |
Character(1) |
VARCHAR2(1) NOT NULL |
Tuition Calc Required Default
N=No
Y=Yes
Default Value: N
|
| 198 |
ACCT_TYPE_WAIVER |
Character(3) |
VARCHAR2(3) NOT NULL |
Excess Waiver Acct Type
Prompt Table:
ACCT_TYP_TBL_SF
|
| 199 |
DEFLT_TERM_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Term Control
E=Most Current Enrollment Term
L=Latest Enrollment Term
T=Use SF Term Default
Default Value: E
|
| 200 |
MOVE_INIT_FA |
Character(1) |
VARCHAR2(1) NOT NULL |
Move Init Financial Aid
Y/N Table Edit
Default Value: Y
|
| 201 |
MOVE_INIT_PMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Move Init Payment
Y/N Table Edit
Default Value: Y
|
| 202 |
MOVE_INIT_WAIVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Move Init Waiver
Y/N Table Edit
Default Value: Y
|
| 203 |
ORG_CONTACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contact Type
|
| 204 |
SF_CREATE_ITEM_DSB |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Item with Disburse Date
Y/N Table Edit
Default Value: N
|
| 205 |
MAINTAIN_GL_HIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintain GL Interface History
Y/N Table Edit
Default Value: N
|
| 206 |
BI_CANC_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Billing Cancellation Number
|
| 207 |
AUTO_TUITION_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Tuition Calc if Needed
Y/N Table Edit
Default Value: Y
|
| 208 |
DED_ANTI_AID_TOTAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Deduct Antic Aid from Total
Y/N Table Edit
Default Value: Y
|
| 209 |
DISP_ANTIC_AID |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Anticipated Aid
Y/N Table Edit
Default Value: Y
|
| 210 |
DISP_PER_CLAS_CHRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Per Class Charges
Y/N Table Edit
Default Value: Y
|
| 211 |
CALC_TUIT_GRADES |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc Tuition after Grade Post
Y/N Table Edit
Default Value: N
|
| 212 |
IND_IND_SP_MIN_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Ind - Ind Sponsor Min Amt
|
| 213 |
IND_ORG_SP_MIN_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Ind - Org Sponsor Min Amt
|
| 214 |
ORG_IND_SP_MIN_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Org - Ind Sponsor Min Amt
|
| 215 |
ORG_ORG_SP_MIN_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Org - Org Sponsor Min Amt
|
| 216 |
LOAD_CRITERIA_TBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Load Criteria Table
|
| 217 |
SF_ENABLE_WEB_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Accept Self-Service Payments
Y/N Table Edit
Default Value: N
|
| 218 |
SF_TAX_DUE_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Due Date
1=NULL
2=Charge Due Date
3=Charge Effective Date
4=Posting Date
Default Value: 1
|
| 219 |
ROUND_AVERAGE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Rounding
R=Round Down
T=No Rounding
U=Round Up
|
| 220 |
TAX_COMBINE_DISPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Display - Combine Tax
|
| 221 |
BILL_COMMIT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Commit Option
E=Commit at the End
L=Commit Level
V=Commit Every Transaction
Default Value: V
|
| 222 |
BILL_COMMIT_LEVEL |
Number(6,0) |
INTEGER NOT NULL |
Billing Commit Level
|
| 223 |
GST_REGISTRATION |
Character(15) |
VARCHAR2(15) NOT NULL |
Cdn GST Registration Number
|
| 224 |
NAME_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Name Usage
Default Value: NAME_PREF
|
| 225 |
SSF_LATEFEE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used to identify which Late Fee processing method will be used by the Business Unit.
B=Late Fee - Billing Request Nbr
C=Late Fee - Past Due/Aging
Default Value: C
|
| 226 |
SSF_REFERENCE_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies the field that will be used for applying payments.
1=Reference Number
2=Invoice ID
|
| 227 |
SERVICE_IMPACT_SF |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Impact SF
|
| 228 |
SSF_ORG_SRV_IND_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Service Indicator for Org.
|