FF_VRBLDEF_A_VW

(SQL View)
 Index Back

SELECT FF_VAR_NAME , FF_DATA_TYPE , FF_VAR_TYPE , %Substring(DESCRLONG,1,30) FROM PS_FF_VARIABLE_TBL WHERE FF_VAR_TYPE <>'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FF_DSCOLABEL Character(100) VARCHAR2(100) NOT NULL Data Fields
2 FF_DATA_TYPE Character(1) VARCHAR2(1) NOT NULL Flat File Data Type
0=Character
2=Number
4=Date
5=Time
6=DateTime
3 FF_VAR_TYPE Character(1) VARCHAR2(1) NOT NULL Flat file Variable Type
C=Constant
S=System
X=Calculated
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description