REQ_CHNG_ADDR (SQL Table)	Index Back
One Time Address Changes Requisition one time address changes

REQ_CHNG_ADDR

(SQL Table)

One Time Address Changes

Requisition one time address changes

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

5 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number

6 CHNG_TYPE Character(1) VARCHAR2(1) NOT NULL Change Type
C=Change
D=Deleted
H=Hold
I=Inserted
N=New
O=Original
R=Re-open
X=Cancelled
Default Value: C

7 REASON_SEQ Number(5,0) INTEGER NOT NULL Reason Sequence
Default Value: 0

8 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number

9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

10 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

11 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

12 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

13 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

14 CITY Character(30) VARCHAR2(30) NOT NULL City

15 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

16 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

17 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

18 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

19 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

20 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

21 COUNTY Character(30) VARCHAR2(30) NOT NULL County

22 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

23 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

24 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

25 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

26 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix

27 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

28 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension

29 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

30 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.

31 LAST_DTTM_UPDATE 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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
5	CHNG_ORD_SEQ	Number(3,0)	SMALLINT NOT NULL	Change Order Sequence Number
6	CHNG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Change Type C=Change D=Deleted H=Hold I=Inserted N=New O=Original R=Re-open X=Cancelled Default Value: C
7	REASON_SEQ	Number(5,0)	INTEGER NOT NULL	Reason Sequence Default Value: 0
8	CHNG_ORD_BATCH	Number(3,0)	SMALLINT NOT NULL	Change Order Number
9	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
10	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
11	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
12	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
13	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
14	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
15	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
16	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
17	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
18	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
19	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
20	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
21	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
22	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
23	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
24	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
25	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
26	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
27	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
28	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
29	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
30	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
31	LAST_DTTM_UPDATE	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.