AGC_TEMPLATE_IDDOC_GROUP_IDDOCUMENT_IDEFFDTDefault Value: %date
A=Active
I=Inactive
A=Acknowledge Document
N=None
U=Upload Document
HR_OBD_CFG_ATVW(SQL View) |
Index Back |
|---|---|
OnBoarding AG DocumentsReturns all documents that have a stored attachment. |
| SELECT T.AGC_TEMPLATE_ID , T.DOC_GROUP_ID , A.DOCUMENT_ID , A.EFFDT , A.EFF_STATUS , A.ATTACH_DESCR , A.DESCRLONG , A.URL_ID , A.ATTACHSYSFILENAME , A.ATTACHUSERFILE , A.ATTACH_EMP_ACTION FROM PS_HR_OBD_CFG_ATT A , PS_HR_OBD_CFG_ATMP T WHERE A.DOCUMENT_ID = T.DOCUMENT_ID AND A.EFFDT = T.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AGC_TEMPLATE_ID |
Character(7) | VARCHAR2(7) NOT NULL | Activity Guide Composer Template Id |
| 2 | DOC_GROUP_ID |
Character(12) | VARCHAR2(12) NOT NULL | Document Group |
| 3 | DOCUMENT_ID |
Character(12) | VARCHAR2(12) NOT NULL | Document Id |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | ATTACH_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Document |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |
| 8 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
| 9 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 10 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 11 | ATTACH_EMP_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Employee Action Required
A=Acknowledge Document N=None U=Upload Document |