HMCF_SPEDTYP_VW

(SQL View)
 Index Back

Speed Type View


SELECT SETID ,SPEEDTYPE_KEY ,DESCR ,ACCOUNT ,DEPTID ,PROJECT_ID ,' ' ,FUND_CODE ,PROGRAM_CODE ,CLASS_FLD ,AFFILIATE ,' ' ,' ' ,BUDGET_REF ,CHARTFIELD1 ,CHARTFIELD2 ,CHARTFIELD3 ,AFFILIATE_INTRA1 ,AFFILIATE_INTRA2 FROM %Table(SPEEDTYP_TBL)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
5 DEPTID_CF Character(10) VARCHAR2(10) NOT NULL Department
6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
7 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
8 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
9 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
10 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
11 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
12 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
13 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
14 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
15 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
16 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
17 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
18 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
19 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate