FO_PNDG_ORD_TBL (SQL Table)	Index Back
Applicant Order Relationship Table that holds the relationship between applicants and Orders

FO_PNDG_ORD_TBL

(SQL Table)

Applicant Order Relationship

Table that holds the relationship between applicants and Orders

Parent record: APPLICANT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

4 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

5 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	APPLID	Character(11)	VARCHAR2(11) NOT NULL	External Job Applicant ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
4	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
5	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.