SCCFP_PS_MAP (SQL Table)	Index Back
File Parser PS Mapping Defin File Parser Mapping Definition - the parent to the file layout and mapping tables.

SCCFP_PS_MAP

(SQL Table)

File Parser PS Mapping Defin

File Parser Mapping Definition - the parent to the file layout and mapping tables.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCCFP_MAP_ID Number(15,0) DECIMAL(15) NOT NULL Mapping ID - the unique key that identifies the file mapping

2 SCCFP_MAP_NAME Character(30) VARCHAR2(30) NOT NULL File Mapping name - the user key to a File Mapping

3 SCCPS_BIND_VIEW Character(15) VARCHAR2(15) NOT NULL Bind view used for the pop selection feature. This view contains the required fields for a paticular context.
Prompt Table: RECDEFN_VW

4 SCCFP_PUBLIC_MAP Character(1) VARCHAR2(1) NOT NULL File Parser Public / Private indicator
Y/N Table Edit
Default Value: N

5 SCCFP_HEADER Character(1) VARCHAR2(1) NOT NULL File Parser automap from header indicator
Y/N Table Edit
Default Value: N

6 SCCFP_HEADER_ROW Number(3,0) SMALLINT NOT NULL File Parser Header Row Number

7 SCCFP_FILE_TYPE Character(1) VARCHAR2(1) NOT NULL File Type - CSV, Flat File, XML etc
D=Delimited
F=Flat
Default Value: D

8 SCCFP_DELIMITER Character(1) VARCHAR2(1) NOT NULL File Parser Field Delimiter (e.g. Comma, Tab, etc)
C=Comma
P=Pipe
T=Tab
X=Semicolon
Default Value: C

9 SCCFP_FIELD_QUAL Character(1) VARCHAR2(1) NOT NULL File Parser Field Qualifier
Default Value: "

10 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

11 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

13 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

14 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

15 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID

16 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCCFP_MAP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Mapping ID - the unique key that identifies the file mapping
2	SCCFP_MAP_NAME	Character(30)	VARCHAR2(30) NOT NULL	File Mapping name - the user key to a File Mapping
3	SCCPS_BIND_VIEW	Character(15)	VARCHAR2(15) NOT NULL	Bind view used for the pop selection feature. This view contains the required fields for a paticular context. Prompt Table: RECDEFN_VW
4	SCCFP_PUBLIC_MAP	Character(1)	VARCHAR2(1) NOT NULL	File Parser Public / Private indicator Y/N Table Edit Default Value: N
5	SCCFP_HEADER	Character(1)	VARCHAR2(1) NOT NULL	File Parser automap from header indicator Y/N Table Edit Default Value: N
6	SCCFP_HEADER_ROW	Number(3,0)	SMALLINT NOT NULL	File Parser Header Row Number
7	SCCFP_FILE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	File Type - CSV, Flat File, XML etc D=Delimited F=Flat Default Value: D
8	SCCFP_DELIMITER	Character(1)	VARCHAR2(1) NOT NULL	File Parser Field Delimiter (e.g. Comma, Tab, etc) C=Comma P=Pipe T=Tab X=Semicolon Default Value: C
9	SCCFP_FIELD_QUAL	Character(1)	VARCHAR2(1) NOT NULL	File Parser Field Qualifier Default Value: "
10	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
11	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
12	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
14	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
15	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
16	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name