FF_FILE_NAMEFF_VERSIONFF_SECTIONIDFF_SECTIONTYPE1=Header
2=Detail
3=Group
4=Trailer
FF_SUBSECTIONA=Additional Record
D=Group Detail
H=Group Header
N=None
T=Group Trailer
FF_DSCOLFLDLANGUAGE_CDFF_DSCLFRMT_LNG(SQL Table) |
Index Back |
|---|---|
Flat file column formatsFlat file column formatting details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FF_FILE_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Flat file name |
| 2 | FF_VERSION |
Character(30) | VARCHAR2(30) NOT NULL | Message Version |
| 3 | FF_SECTIONID |
Character(30) | VARCHAR2(30) NOT NULL | Flat file section type |
| 4 | FF_SECTIONTYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Flat file section type
1=Header 2=Detail 3=Group 4=Trailer |
| 5 | FF_SUBSECTION |
Character(1) | VARCHAR2(1) NOT NULL |
Flat file subsection type
A=Additional Record D=Group Detail H=Group Header N=None T=Group Trailer |
| 6 | FF_DSCOLFLD |
Character(30) | VARCHAR2(30) NOT NULL | Flat file data source field |
| 7 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |