ITEM_TYPE_TBL - Item Type Table

ITEM_TYPE_TBL contains detailed information about Finance Item Types

Detailed Information

Data Systems

PeopleSoft Campus Solutions - CSPRD
PeopleSoft Campus Solutions Reporting - CSRPT

Record.Fieldname Format XLAT Heading Text
ACCTG_DT_CNTL - Accounting Date Control Char1 N Control
ADJUSTMENT_CAL_SF - Adjustment Calendar Char8   Adj Cal
ALL_OR_NONE - Pay All or None Char1   All/None
CHARGE_PRIORITY - Charge Priority List Char8   Charge Lst
CURRENCY_CD - Currency Code Char3   Currency
DAYS_SINCE_EFFDT - Days Past Since Effdt Num5.0   Days
DAYS_TO_EFFDT - Days to Effdt Num5.0   Days
DEFAULT_AMT - Default Amount SNm14.2   Default Amt
DESCR - Description Char30   Descr
DESCRSHORT - Short Description Char10   Short Desc
DUEDAYS_PAST_EFFDT - Nbr of Days Past Effdt Num5.0   Days Past
DUEDAYS_PRIOR_EFFD - Nbr of Days Before Effdt Num5.0   Days Until
EFFDT - Effective Date Date   Eff Date
EFF_STATUS - Status as of Effective Date Char1 N Status
ENCUMBRANCE_DAYS - Days to Encumber Num3.0   Encumber
ENCUMBRANCE_PCT - Encumbrance Pct Num3.6   Encmbr Pct
ENROL_FLAG - Enrolled Flag Char1   Enrolled
ERNCD - Earnings Code Char3   Earn Code
ERNCD_NOTAX - Earnings Code Non Taxable Char3   Earnings
GL_CRSE_CLASS_SPC - Course Class Specific Char1   Course Class
GL_INTERFACE_REQ - GL Interface Required Char1   Required
ITEM_TYPE - Item Type Char12   Item Type
ITEM_TYPE_CD - Item Type Code Char1 N Item Code
KEYWORD1 - Key Word Char10   Key Word
KEYWORD2 - Key Word 2 Char10   Key Word 2
KEYWORD3 - Key Word 3 Char10   Key Word 3
LOCAL_TAX_OFFSET - Local Tax Offset Char1   Local Offset
LOCAL_TAX_PMT - Local Tax Payment Char1   Local Payment
MATCH_WRITEOFF - Match Charge Write-Offs Char1   Match Charges
MAXIMUM_AMT - Maximum Transaction Amount SNm14.2   Max Amt
MINIMUM_AMT - Mininum Transaction Amount SNm14.2   Min Amt
NRA_CREDIT_TAX_FLG - NRA Tax Payment Flag Char1   NRA Tax Pay FLG
NRA_DEBIT_TAX_FLG - NRA Tax Type Char1   NRA Tax Type
PAYMENT_PRIORITY - Payment Priority Char8   Pay Prior.
PAYMENT_TERMS - Payment Terms Char8   Pay Terms
PAY_PRIORITY_ID - Payment Overall Priority Char8   Pmt Overall Pri
PRIORITY - Priority Num3.0   Priority
PRIORITY_PMT_FLG - Payment Priority Flag Char1   Pmt. Priority
RECVABLE_FROM_CHRG - Pick up Receivable from Charge Char1   Recv. from Chrg
REFUNDABLE_IND - Refundable Indicator Char1   Refund Ind
SCC_SFP_FA_ELIG - Financial Aid Eligible Char1   FA Eligible
SCC_SFP_RETN4_ONLY - Return to Title IV Only Char1   Title IV Only
SECURITY_GROUP - Security Group Char8   Sec Grp
SETID - SetID Char5   SetID
SFA_EA_PROGRAM_CD - External Award Program Code Char3   Program Code
SFA_EA_SOURCE - External Award Source Char3   Source
SFA_EA_TYPE - External Award Type Char3   Award Type
SF_1098_FLG - 1098-T Eligible Char1   1098-T Eligible
SSF_1098_WVR_OFFST - Do not Offset Reported Tuition Char1   Not Offset Box2
SSF_ACCTG_DT_ID - Accounting Date ID Char3   Acctg Dt ID
SSF_BILL_GBL_INV - Include in Global Invoicing Char1   Global Invoice
SSF_DEST_TUT_TYPE - DEST Tuition Type Char1 N DEST Tuit Type
SSF_SFP_AAID_EXPD - Anticipate Aid Expiration Days Num3.0   Expiration Days
SSF_SFP_DAYS_AFTER - Days After Term Num3.0   Days After Term
SSF_SFP_DAYS_PRIOR - Days Prior to Term Num3.0   Days Prior
SSF_SFP_DAYS_TERM - Days Term Char1 N Days Term
SSF_SFP_DISP_AAID - Display Anticipated Aid Char4 N Display Anticip
SSF_SFP_SAVE_EST - Save Estimated Award Char1   Save Estimated
SSF_SFP_SCHL_CRDBL - School Credit Balance Char4 N Schl Cred Bal
SSF_SFP_TRM_STRTDT - Term Start Date Char1   Term Start Date
SSF_STATE_FLAG - State Char1 N State
STATE_TAX_OFFSET - State Tax Offset Char1   State Offset
STATE_TAX_PMT - State Tax Payment Char1   State Payment
T2202A_FLG - T2202A Eligible Char1   T2202A Eligible
T2202A_OFFSET_FLG - T2202A Offset Char1   T2202A Offset
T2202A_PCT - T2202A Percent Num2.3   T2202A Percent
T4_INCOME - T4A Eligible Char1   T4A Eligible
TAXABLE_Y_N - Taxable Char1   Taxable
TAX_CD - Tax Code Char8   Code
TENDER_CATEGORY - Tender Category Char3 N Category
TENDER_SPEC - Tender Specific Char1   Specific
TERM_ENROLL_REQ - Term Enroll Req for Posting Char1   Enroll Req
TUITION_DEPOSIT - Tuition Deposit Char1   Tuit Dep
WAGE_LOSS_PLAN - Wage Loss Replacement Plan Char3   WageLossPl

 

Submit an Inquiry or Request to DARTS Print Article

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)