ORD_HEADER_SHIP (SQL Table)	Index Back
Sales Order Mass Update Used for sales order Mass Update Date Initials Issue Description 091801 dms F-CJORGENS-11 Add REASON_CD

ORD_HEADER_SHIP

(SQL Table)

Sales Order Mass Update

Used for sales order Mass Update Date Initials Issue Description 091801 dms F-CJORGENS-11 Add REASON_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

3 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
Prompt Table: SP_BUIN_NONVW

4 AERP Character(50) VARCHAR2(50) NOT NULL Automated Exporter Rptg Prgm

5 SEL_AERP Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

6 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes

7 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
Prompt Table: %EDITTABLE8

8 SEL_CARRIER_ID Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

9 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
Prompt Table: %EDITTABLE8

10 SEL_CARRIER_ID_EXP Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

11 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes

12 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes

13 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
N=No
Y=Yes

14 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
Prompt Table: CM_DISTR_TYPE

15 SELECT_DISTR_TYPE Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

16 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

17 EXPORT_APPL_DT Date(10) DATE Application Date

18 SELECT_EXP_APPL_DT Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

19 EXPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes

20 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date

21 SELECT_EXP_LIC_EXP Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

22 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr

23 SELECT_EXP_LIC_NBR Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

24 EXPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes

25 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes

26 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific

27 EXPORT_LIC_VALUE Number(10,2) DECIMAL(9,2) NOT NULL License Value

28 SELECT_EXP_LIC_VAL Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

29 EXPORT_REC_DT Date(10) DATE Date Received

30 SELECT_EXP_REC_DT Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

31 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
Prompt Table: %EDITTABLE7

32 SEL_FRT_TERMS Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

33 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
Prompt Table: %EDITTABLE7

34 SEL_FRT_TERMS_EXP Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

35 IMPORT_APPL_DT Date(10) DATE Application Date

36 SELECT_IMP_APPL_DT Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

37 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr

38 SELECT_IMP_CERTNBR Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

39 IMPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes

40 IMPORT_LIC_EXP Date(10) DATE Expiration Date

41 SELECT_IMP_LIC_EXP Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

42 IMPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes

43 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes

44 IMPORT_REC_DT Date(10) DATE Date Received

45 SELECT_IMP_REC_DT Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

46 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule
Prompt Table: IN_RULE_B_VW

47 SEL_IN_LN_BO_RULE Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

48 IN_LINE_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation Rule
Prompt Table: IN_RULE_R_VW

49 SEL_IN_LN_RESV_RUL Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

50 IN_LN_RESV_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation - Backorder
Prompt Table: IN_RULE_R_VW

51 SEL_IN_LN_RESV_BO Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

52 IN_ORDER_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Order Reservation Rule
Prompt Table: IN_RULE_O_VW

53 SEL_IN_ORD_RES_RUL Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

54 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes

55 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
Prompt Table: %EDITTABLE12

56 SELECT_LOAD_ID Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

57 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes

58 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
Prompt Table: REASON_SHIP_VW

59 SELECT_REASON_CD Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

60 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
Prompt Table: %EDITTABLE13

61 SELECT_ROUTE_CD Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

62 SCHED_ARRV_DATE Date(10) DATE Scheduled Arrival Date

63 SCHED_ARRV_TIME Time(15) TIMESTAMP Scheduled Arrival Time

64 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date

65 SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time

66 SELECT_SCH_ARRV_DT Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

67 SELECT_SCH_SHIP_DT Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

68 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes

69 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes

70 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
N=Partial Order No
Y=Partial Order Yes

71 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority
Prompt Table: %EDITTABLE6

72 SEL_SHIP_PRI_EXP Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

73 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
Prompt Table: %EDITTABLE6

74 SEL_SHIP_PRIORITY Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

75 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes

76 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
Prompt Table: %EDITTABLE4

77 SEL_SHIP_TYPE_ID Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

78 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
Prompt Table: %EDITTABLE4

79 SEL_SHIP_TYPE_EXP Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit
Default Value: N

80 SELECT_CUST_PO Character(1) VARCHAR2(1) NOT NULL Date Initials Issuse Description 032307 LPL F-CJORG-A5ZU6 New field
Y/N Table Edit
Default Value: N

81 CUSTOMER_PO_UPD Character(25) VARCHAR2(25) NOT NULL Date Initials Issuse Description 032307 LPL F-CJORG-A5ZU6 New field

82 SEL_PROJECT Character(1) VARCHAR2(1) NOT NULL Select Project
Y/N Table Edit
Default Value: N

83 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

84 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

85 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

86 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

87 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

88 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

89 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

90 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

91 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

92 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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU Prompt Table: SP_BUIN_NONVW
4	AERP	Character(50)	VARCHAR2(50) NOT NULL	Automated Exporter Rptg Prgm
5	SEL_AERP	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
6	BCKORDR_CNCL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cancel Backorder N=Cancel Backorder No Y=Cancel Backorder Yes
7	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID Prompt Table: %EDITTABLE8
8	SEL_CARRIER_ID	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
9	CARRIER_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Carrier ID Prompt Table: %EDITTABLE8
10	SEL_CARRIER_ID_EXP	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
11	CCI_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Canadian Customs Invoice N=No Y=Yes
12	COO_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Certificate of Origin N=No Y=Yes
13	CUST_PICKUP	Character(1)	VARCHAR2(1) NOT NULL	Counter sale customer pickup flag N=No Y=Yes
14	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type Prompt Table: CM_DISTR_TYPE
15	SELECT_DISTR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
16	EXPORT	Character(1)	VARCHAR2(1) NOT NULL	Export Analytic Instance N=No Y=Yes
17	EXPORT_APPL_DT	Date(10)	DATE	Application Date
18	SELECT_EXP_APPL_DT	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
19	EXPORT_LIC_APPL	Character(3)	VARCHAR2(3) NOT NULL	Applied For NO=No YES=Yes
20	EXPORT_LIC_EXPIRE	Date(10)	DATE	Expiration Date
21	SELECT_EXP_LIC_EXP	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
22	EXPORT_LIC_NBR	Character(18)	VARCHAR2(18) NOT NULL	Export License Nbr
23	SELECT_EXP_LIC_NBR	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
24	EXPORT_LIC_REC	Character(3)	VARCHAR2(3) NOT NULL	License Received NO=No YES=Yes
25	EXPORT_LIC_REQ	Character(3)	VARCHAR2(3) NOT NULL	Export License Required NO=No YES=Yes
26	EXPORT_LIC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	License Type GDST=General SPEC=Specific
27	EXPORT_LIC_VALUE	Number(10,2)	DECIMAL(9,2) NOT NULL	License Value
28	SELECT_EXP_LIC_VAL	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
29	EXPORT_REC_DT	Date(10)	DATE	Date Received
30	SELECT_EXP_REC_DT	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
31	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: %EDITTABLE7
32	SEL_FRT_TERMS	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
33	FREIGHT_TERMS_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Freight Terms Code Prompt Table: %EDITTABLE7
34	SEL_FRT_TERMS_EXP	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
35	IMPORT_APPL_DT	Date(10)	DATE	Application Date
36	SELECT_IMP_APPL_DT	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
37	IMPORT_CERT_NBR	Character(18)	VARCHAR2(18) NOT NULL	Import License Nbr
38	SELECT_IMP_CERTNBR	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
39	IMPORT_LIC_APPL	Character(3)	VARCHAR2(3) NOT NULL	Applied For NO=No YES=Yes
40	IMPORT_LIC_EXP	Date(10)	DATE	Expiration Date
41	SELECT_IMP_LIC_EXP	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
42	IMPORT_LIC_REC	Character(3)	VARCHAR2(3) NOT NULL	License Received NO=No YES=Yes
43	IMPORT_LIC_REQ	Character(3)	VARCHAR2(3) NOT NULL	Import License Required NO=No YES=Yes
44	IMPORT_REC_DT	Date(10)	DATE	Date Received
45	SELECT_IMP_REC_DT	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
46	IN_LINE_BO_RULE	Character(10)	VARCHAR2(10) NOT NULL	Line Backorder Rule Prompt Table: IN_RULE_B_VW
47	SEL_IN_LN_BO_RULE	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
48	IN_LINE_RESV_RULE	Character(10)	VARCHAR2(10) NOT NULL	Line Reservation Rule Prompt Table: IN_RULE_R_VW
49	SEL_IN_LN_RESV_RUL	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
50	IN_LN_RESV_BO_RULE	Character(10)	VARCHAR2(10) NOT NULL	Line Reservation - Backorder Prompt Table: IN_RULE_R_VW
51	SEL_IN_LN_RESV_BO	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
52	IN_ORDER_RESV_RULE	Character(10)	VARCHAR2(10) NOT NULL	Order Reservation Rule Prompt Table: IN_RULE_O_VW
53	SEL_IN_ORD_RES_RUL	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
54	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag N=No Y=Yes
55	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID Prompt Table: %EDITTABLE12
56	SELECT_LOAD_ID	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
57	NAFTA_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	North American Free Trade Agmt N=No Y=Yes
58	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code Prompt Table: REASON_SHIP_VW
59	SELECT_REASON_CD	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
60	ROUTE_CD	Character(6)	VARCHAR2(6) NOT NULL	A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles. Prompt Table: %EDITTABLE13
61	SELECT_ROUTE_CD	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
62	SCHED_ARRV_DATE	Date(10)	DATE	Scheduled Arrival Date
63	SCHED_ARRV_TIME	Time(15)	TIMESTAMP	Scheduled Arrival Time
64	SCHED_SHIP_DATE	Date(10)	DATE	Scheduled Ship Date
65	SCHED_SHIP_TIME	Time(15)	TIMESTAMP	Scheduled Ship Time
66	SELECT_SCH_ARRV_DT	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
67	SELECT_SCH_SHIP_DT	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
68	SED_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Shippers Export Declaration N=No Y=Yes
69	SHIP_PARTIAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Schedules N=Ship Partial No Y=Ship Partial Yes
70	SHIP_PARTIAL_ORD	Character(1)	VARCHAR2(1) NOT NULL	Partial Order N=Partial Order No Y=Partial Order Yes
71	SHIP_PRIORITY_EXP	Character(6)	VARCHAR2(6) NOT NULL	Export Shipping Priority Prompt Table: %EDITTABLE6
72	SEL_SHIP_PRI_EXP	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
73	SHIP_PRIORITY_ID	Character(6)	VARCHAR2(6) NOT NULL	Shipping Priority Code Prompt Table: %EDITTABLE6
74	SEL_SHIP_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
75	SHIP_PRIOR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Ship Prior to Request Date N=Ship Prior No Y=Ship Prior Yes
76	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: %EDITTABLE4
77	SEL_SHIP_TYPE_ID	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
78	SHIP_TYPE_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Shipping Method Prompt Table: %EDITTABLE4
79	SEL_SHIP_TYPE_EXP	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit Default Value: N
80	SELECT_CUST_PO	Character(1)	VARCHAR2(1) NOT NULL	Date Initials Issuse Description 032307 LPL F-CJORG-A5ZU6 New field Y/N Table Edit Default Value: N
81	CUSTOMER_PO_UPD	Character(25)	VARCHAR2(25) NOT NULL	Date Initials Issuse Description 032307 LPL F-CJORG-A5ZU6 New field
82	SEL_PROJECT	Character(1)	VARCHAR2(1) NOT NULL	Select Project Y/N Table Edit Default Value: N
83	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
84	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
85	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
86	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
87	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
88	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
89	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
90	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
91	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
92	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.