CS_DOC_IDCS_AMENDED_SVW(SQL View) |
Index Back |
|---|---|
Amended Signed copies viewDate Initials Issue Description ============================================ 09/2007 CEL F-AHAYT-25EQ8 Amended signed copies views |
| SELECT A.CS_DOC_ID , A.SCM_ATTACH_ID , A.ATT_VERSION , 'N' , B.CS_AMENDMENT , A.CS_DOC_SIGN_VER FROM PS_CS_DOC_SIGN_HST A , PS_CS_DOC_HDR_HIST B WHERE A.CS_DOC_ID = B.CS_DOC_ID AND A.CS_DOC_SIGN_VER = B.CS_DOC_SIGN_VER AND A.CS_DOC_TYPE = '009' AND B.CS_DOC_ACTION = '09' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_ID |
Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 2 | SCM_ATTACH_ID | Character(64) | VARCHAR2(64) NOT NULL | The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications. |
| 3 | ATT_VERSION | Number(3,0) | SMALLINT NOT NULL | The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files. |
| 4 | CS_IMPORT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Imported Document |
| 5 | CS_AMENDMENT | Number(3,0) | SMALLINT NOT NULL | Amendment |
| 6 | CS_DOC_SIGN_VER | Number(5,0) | INTEGER NOT NULL | Signing Version Number |