ORG_CHK_ITEM (SQL Table)	Index Back
Organization Checklist Item ORG_CHK_ITEM stores the items associated with an organization's checklist. There is one record in this table for each item or sequence number within a dated list.

ORG_CHK_ITEM

(SQL Table)

Organization Checklist Item

ORG_CHK_ITEM stores the items associated with an organization's checklist. There is one record in this table for each item or sequence number within a dated list.

Parent record: ORG_CHECKLIST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
Prompt Table: EXT_ORG_TBL

2 CHECKLIST_DTTM DateTime(26) TIMESTAMP NOT NULL Checklist Date Time
Prompt Table: ORG_CHECKLIST

3 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence

4 CHKLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Checklist Item Code
Prompt Table: CHKLST_ITEM_VW

5 ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
A=Active
C=Completed
I=Initiated
N=Notified
O=Ordered
P=Paid Off
R=Received
S=Second Notification
T=Returned
W=Waived
X=Cancelled
Default Value: I

6 STATUS_DT Date(10) DATE NOT NULL Status Date
Default Value: ORG_CHECKLIST.STATUS_DT

7 STATUS_CHANGE_ID Character(11) VARCHAR2(11) NOT NULL Status Change ID
Default Value: ORG_CHECKLIST.STATUS_CHANGE_ID
Prompt Table: PEOPLE_SRCH

8 DUE_DT Date(10) DATE NOT NULL Expected Birth Date

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

10 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount

11 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID
Default Value: ORG_CHK_ITEM.STATUS_CHANGE_ID
Prompt Table: PEOPLE_SRCH

12 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr
Default Value: ORG_CHECKLIST.ORG_CONTACT
Prompt Table: ORG_CONTACT

13 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
Default Value: ORG_CHECKLIST.CONTACT_NAME

14 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: EXT_ORG_TBL
2	CHECKLIST_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Checklist Date Time Prompt Table: ORG_CHECKLIST
3	CHECKLIST_SEQ	Number(6,0)	INTEGER NOT NULL	Checklist Sequence
4	CHKLST_ITEM_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Item Code Prompt Table: CHKLST_ITEM_VW
5	ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Item Status A=Active C=Completed I=Initiated N=Notified O=Ordered P=Paid Off R=Received S=Second Notification T=Returned W=Waived X=Cancelled Default Value: I
6	STATUS_DT	Date(10)	DATE NOT NULL	Status Date Default Value: ORG_CHECKLIST.STATUS_DT
7	STATUS_CHANGE_ID	Character(11)	VARCHAR2(11) NOT NULL	Status Change ID Default Value: ORG_CHECKLIST.STATUS_CHANGE_ID Prompt Table: PEOPLE_SRCH
8	DUE_DT	Date(10)	DATE NOT NULL	Expected Birth Date
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
10	DUE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Due Amount
11	RESPONSIBLE_ID	Character(11)	VARCHAR2(11) NOT NULL	Responsible ID Default Value: ORG_CHK_ITEM.STATUS_CHANGE_ID Prompt Table: PEOPLE_SRCH
12	ORG_CONTACT	Number(4,0)	SMALLINT NOT NULL	Contact Nbr Default Value: ORG_CHECKLIST.ORG_CONTACT Prompt Table: ORG_CONTACT
13	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name Default Value: ORG_CHECKLIST.CONTACT_NAME
14	COMM_KEY	Character(8)	VARCHAR2(8) NOT NULL	Communication Speed Key