FF_VAR_NAME0=Character
2=Number
4=Date
5=Time
6=DateTime
C=Constant
S=System
X=Calculated
C=Current Date
D=Current DateTime
N=New Line
S=Sequence Number
T=Current Time
U=UserId
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
FF_VARIABLE_TBL(SQL Table) |
Index Back |
|---|---|
Flat file variablesFlat file variables |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FF_VAR_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Flat file variable name |
| 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 | DESCRLONG | Long Character | CLOB | Long Description |
| 4 | FF_VAR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Flat file Variable Type
C=Constant S=System X=Calculated |
| 5 | FF_SYS_VAR | Character(1) | VARCHAR2(1) NOT NULL |
Flat File System Variable
C=Current Date D=Current DateTime N=New Line S=Sequence Number T=Current Time U=UserId |
| 6 | FF_VAR_VALUE | Character(100) | VARCHAR2(100) NOT NULL | Flat file variable Value |
| 7 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |